PKP PLN Plugin / OJS 3.3.0.14

Hi all

I’m trying to bring some issues of one journal - ID: A2ECA4D5-CDC4-4331-8856-E2C28C678B50 - into PKP’s preservation network.
The plugin was intstalled successfully and the terms of use were marked. The server triggered the cronjob today 0:00 MEZ 15 hours ago. No errors in ojs_error.log
Now the status is still “loading” (see screenshot). I’m doing it for the first time. So I don’t know if this is normal behaviour until the data is pumped trough or something went wrong.

Thanks for help!

I found some information in the scheduled task log file. It seems that some columns were not found.

[2023-12-07 00:00:01] [Notice] Task process started.
[2023-12-07 00:00:01] [Notice] PKP Preservation Network Processor
[2023-12-07 00:00:01] [Notice] Depositor processing for Acta Periodica Duellatorum.
[2023-12-07 00:00:01] [Notice] Getting service document.
[2023-12-07 00:00:02] [Notice] Processing new content.
[2023-12-07 00:00:03] [Error] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'staging_state' in 'field list' in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): PDO->prepare()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(485): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\Database\Connection->run()
#5 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Connection->affectingStatement()
#6 /var/www/ojs/lib/pkp/classes/db/DAO.inc.php(140): Illuminate\Database\Capsule\Manager::__callStatic()
#7 /var/www/ojs/plugins/generic/pln/classes/DepositDAO.inc.php(77): DAO->update()
#8 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(287): DepositDAO->insertObject()
#9 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(110): Depositor->_processNewDepositObjects()
#10 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#11 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#12 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#13 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#14 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#15 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'staging_state' in 'field list' in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(85): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(485): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\Database\Connection->run()
#5 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Connection->affectingStatement()
#6 /var/www/ojs/lib/pkp/classes/db/DAO.inc.php(140): Illuminate\Database\Capsule\Manager::__callStatic()
#7 /var/www/ojs/plugins/generic/pln/classes/DepositDAO.inc.php(77): DAO->update()
#8 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(287): DepositDAO->insertObject()
#9 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(110): Depositor->_processNewDepositObjects()
#10 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#11 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#12 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#13 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#14 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#15 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'staging_state' in 'field list' (SQL: INSERT INTO pln_deposits
                                        (journal_id,
                                        uuid,
                                        status,
                                        staging_state,
                                        lockss_state,
                                        date_status,
                                        date_created,
                                        date_modified,
                                        date_preserved)
                                VALUES
                                        (32, 5CC3DECC-F0DB-4CB9-9894-70EA4C601337, 0, ?, ?, NULL, CURRENT_TIMESTAMP, NULL, NULL)) in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\Database\Connection->run()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Connection->affectingStatement()
#3 /var/www/ojs/lib/pkp/classes/db/DAO.inc.php(140): Illuminate\Database\Capsule\Manager::__callStatic()
#4 /var/www/ojs/plugins/generic/pln/classes/DepositDAO.inc.php(77): DAO->update()
#5 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(287): DepositDAO->insertObject()
#6 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(110): Depositor->_processNewDepositObjects()
#7 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#8 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#9 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#10 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#11 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#12 {main}
[2023-12-07 00:00:03] [Notice] Processing updated content.
[2023-12-07 00:00:03] [Notice] Packaging content for deposit.
[2023-12-07 00:00:03] [Error] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): PDO->prepare()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#7 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(227): DAOResultFactory->next()
#8 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(126): Depositor->_processNeedPackaging()
#9 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#10 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#11 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#12 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#13 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#14 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(85): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#7 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(227): DAOResultFactory->next()
#8 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(126): Depositor->_processNeedPackaging()
#9 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#10 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#11 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#12 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#13 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' (SQL: SELECT *
                        FROM pln_deposits AS d
                        WHERE d.journal_id = 32
                        AND d.status & 1 = 0
                        ORDER BY d.export_deposit_error, d.deposit_id) in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#2 [internal function]: Illuminate\Database\Connection->cursor()
#3 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#4 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(227): DAOResultFactory->next()
#5 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(126): Depositor->_processNeedPackaging()
#6 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#7 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#8 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#9 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#10 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#11 {main}
[2023-12-07 00:00:03] [Notice] Processing deposit status updates.
[2023-12-07 00:00:03] [Error] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): PDO->prepare()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#7 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(162): DAOResultFactory->next()
#8 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(134): Depositor->_processStatusUpdates()
#9 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#10 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#11 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#12 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#13 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#14 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(85): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#7 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(162): DAOResultFactory->next()
#8 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(134): Depositor->_processStatusUpdates()
#9 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#10 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#11 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#12 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#13 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' (SQL: SELECT *
                        FROM pln_deposits AS d
                        WHERE d.journal_id = 32
                        AND (
                                d.status IS NULL
                                OR (
                                        d.status & 2 <> 0
                                        AND d.status & 128 = 0
                                )
                        )
                        ORDER BY d.export_deposit_error, d.deposit_id) in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#2 [internal function]: Illuminate\Database\Connection->cursor()
#3 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#4 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(162): DAOResultFactory->next()
#5 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(134): Depositor->_processStatusUpdates()
#6 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#7 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#8 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#9 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#10 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#11 {main}
[2023-12-07 00:00:03] [Notice] Sending deposits to the PKP PN.
[2023-12-07 00:00:03] [Error] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): PDO->prepare()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#7 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(197): DAOResultFactory->next()
#8 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(142): Depositor->_processNeedTransferring()
#9 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#10 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#11 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#12 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#13 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#14 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' in /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(85): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#5 [internal function]: Illuminate\Database\Connection->cursor()
#6 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#7 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(197): DAOResultFactory->next()
#8 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(142): Depositor->_processNeedTransferring()
#9 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#10 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#11 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#12 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#13 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.export_deposit_error' in 'order clause' (SQL: SELECT *
                        FROM pln_deposits AS d
                        WHERE d.journal_id = 32
                        AND d.status & 1 <> 0
                        AND d.status & 2 = 0
                        ORDER BY d.export_deposit_error, d.deposit_id) in /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
Stack trace:
#0 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run()
#2 [internal function]: Illuminate\Database\Connection->cursor()
#3 /var/www/ojs/lib/pkp/classes/db/DAOResultFactory.inc.php(88): Generator->current()
#4 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(197): DAOResultFactory->next()
#5 /var/www/ojs/plugins/generic/pln/classes/tasks/Depositor.inc.php(142): Depositor->_processNeedTransferring()
#6 /var/www/ojs/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): Depositor->executeActions()
#7 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(111): ScheduledTask->execute()
#8 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(95): ScheduledTaskTool->executeTask()
#9 /var/www/ojs/lib/pkp/classes/cliTool/ScheduledTaskTool.inc.php(67): ScheduledTaskTool->parseTasks()
#10 /var/www/ojs/tools/runScheduledTasks.php(34): ScheduledTaskTool->execute()
#11 {main}
[2023-12-07 00:00:03] [Notice] Pruning orphaned deposits.
[2023-12-07 00:00:03] [Notice] Task process stopped.

Hi @trace!

What’s the output for this query:

SELECT * FROM versions WHERE product = 'pln';

I guess you’ve already had the plugin before and you’ve just upgraded, right? How did you upgrade? Did you use the plugin gallery to upgrade or it was manually (from GitHub)?

Best,
Jonas Raoni

I’ve tested the upgrade on some installations, and it worked fine for me. These two upgrades should have been executed:

Add a missing field (perhaps you don’t have this issue):

And this one to add the new fields that you’re missing, and also to reset the status for all deposits (very important):

Best,
Jonas Raoni

HiJonas

Thanks for your help!

I’ve intalled the plugin for the first time. I didn’t upgrade.

Output is:

# major minor revision build date_installed current product_type product product_class_name lazy_load sitewide
1 1 0 1 0 2015-06-27 01:36:51 1 plugins.generic pln PLNPlugin 1 0

I cannot install from the gallery directly due to the institutional system environment here. So I did it from github. But maybe I did something wrong with that vendor, lib thing. I have to check it.

I will do the installation once again and let you know if it worked.

Best
jan

As you’ve already installed it before, ensure that no traces of the plugin remained before installing again

  • DELETE FROM versions WHERE product = 'pln';
  • DELETE FROM plugin_settings WHERE plugin_name = 'plnplugin';
  • DROP TABLE pln_deposit_objects;
  • DROP TABLE pln_deposits;
  • Remove the old plugin files at plugins/generic/pln

There are three ways to install:

Plugin Gallery

Look for the PKP PN plugin and install.

image

Upload the plugin file using the plugins interface

You can download the latest release here Release PKP|PN 2.0.4-3 - OJS 3.3 · pkp/pln · GitHub, the .tar.gz file

image

Manually

  1. Extract the .tar.gz (find it here Release PKP|PN 2.0.4-3 - OJS 3.3 · pkp/pln · GitHub) in the plugins/generic folder or download the GitHub code and run the composer install (the .tar.gz file is better, the composer files are included and the not needed files are removed)
  2. Run the php lib/pkp/tools/installPluginVersion.php plugins/generic/pln/version.xml

Best,
Jonas Raoni

Thanks Jonas!

I’ve reinstalled and it looks good. The enabled issues are now “in progres”.

php lib/pkp/tools/installPluginVersion.php plugins/generic/pln/version.xml fixed my problem. To run this command is missed in ReadMe as far I remember.

Best

1 Like

Hi Jonas

I’ve now got the error:
The deposit didn’t pass the anti-virus check, you should inspect its files, and resend.

I don’t know what to do. The files aren’t compromised. Can you pass some more imformation how we have to proceed?

ID: A2ECA4D5-CDC4-4331-8856-E2C28C678B50

Thanks
jan

Hi!

That’s an issue on our side, I’ll get it sorted out, and you don’t need to do anything.

Best,
Jonas Raoni

1 Like

Hi!

I think the anti-virus check should be ok by now.

Best,
Jonas

1 Like