Unknown column staging_state in field list (pkp pn)

Software Support
,
1

Hi
After updating the PKP pn version, when I refer to the log, I have the following error:

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘staging_state’ in ‘field list’

Due to server limitations, I have to get the package from GitHub, and it seems that a field has been added in the update

Please guide me to add staging_state field or give me the basic database structure

Also, before this file update, everything was working fine and the new number is not registered now

@jonasraoni

2

also my table schema:

CREATE TABLE `pln_deposits` (
  `deposit_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `uuid` varchar(36) DEFAULT NULL,
  `status` bigint(20) DEFAULT 0,
  `date_status` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `export_deposit_error` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
3

Hi @zerof,

Please access the main OJS directory and execute this command:

php lib/pkp/tools/installPluginVersion.php plugins/generic/pln/version.xml

The plugin has some upgrade scripts, and this should execute them (this happens automatically when installing from the plugin gallery).

Let me know if it worked for you, if not, I’m interested to find what’s wrong :slight_smile:

Best,
Jonas Raoni

4

thanks
I executed this command once through cPanel and cron job section because I use a shared service and do not have access to shell.
But no changes were made in the table structure

I noticed that three fields are missing, isn’t it better to create these 3 manually?

staging_state
lockss_state
date_preserved

5

I was curious to know what happened, as it might help other users with the same limitation :slight_smile:

But if you don’t have time for that, that’s fine, you can run the following SQL:

ALTER TABLE pln_deposits
ADD COLUMN date_preserved DATETIME NULL,
ADD COLUMN staging_state VARCHAR(255) NULL,
ADD COLUMN lockss_state VARCHAR(255) NULL;

UPDATE pln_deposits SET status = NULL;

Best,
Jonas Raoni

6

Thanks, the table is updated, I hope the plugin works well too

7

This version should fix a lot of problems.

The query that you executed should also reset the status of the deposits, which will be retrieved from the server on the next synchronization (tomorrow).

Best,
Jonas Raoni

8

Please note:
this command don’t works because of an error in the path to version.xml file.
To make the command work you have to remove the “/” (slash) before “plugins/generic/pln/version.xml”
This is the correct command:
php lib/pkp/tools/installPluginVersion.php plugins/generic/pln/version.xml

9

Hi @jonasraoni
I have the same issue of @zerof .
I updated the PKP PN plugin to 2.0.4.5 version via the Plugin Gallery.
My OJS version is 3.3.0-13

It seams that updating via Plugin Gallery does not execute the upgrade scripts as it is supposed to do.

10

Thanks! Given that other people are having the same problem, I’ll probably update the plugin to ensure the upgrade scripts were executed at least once.

Best,
Jonas Raoni

1 Like
12

I’ve created one issue here: Upgrade issues · Issue #101 · pkp/pln · GitHub, to ensure the upgrade scripts are executed, and I’m planning to release on the next version. So I’ll close this topic.

Best,
Jonas Raoni