PKP PN plugin error posible solution

Hi @asmecher
The current version of the PKP PN plugin maybe has a very tiny bug that causes errors to occur where it doesn’t find a field called export_deposit_error:

PHP Notice: Undefined index: export_deposit_error


PHP Fatal error: Uncaught Exception: DB Error: Unknown column ‘export_deposit_error’ in ‘field list’

On fresh installations, the plugin installs the schema without problems, but on upgrades from previous versions it does not update the schema.

I found this, because since I updated to the new version in OJS3.3.0.8 and PKP PN v2.0.4.2 release on 2021-07-28 I have not had any backup news, coincidentally since July 2021.

This was consistent across 15+ journals upgraded from OJS2 to OJS3.3.x

Reading your answer, what I did was add the field to the pnl_deposits table like this:

ALTER TABLE `pln_deposits` ADD `export_deposit_error` VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `date_modified`;

With this, the plugin finished sending error messages and I am waiting for the backups to be made in PKP-PN. (I’m crossing fingers)


Hi @dagosalas,

Thanks for sharing. Flagging this for @asmecher’s attention.

PKP Team

1 Like

Hi @dagosalas,

How did you upgrade the plugin?

Alec Smecher
Public Knowledge Project Team

Hi @asmecher
Initially it was an upgrade from OJS2.x to OJS3.3x, and the plugins are all updated from the plugin gallery.
I did it in 15+ journals and all of them were missing that field.
But on fresh installations, it does contain the full schema. No problems there.