trace
December 7, 2023, 2:01pm
1
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!
trace
December 7, 2023, 3:40pm
2
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):
<?php
/**
* @file classes/migration/upgrade/I35_FixMissingField.inc.php
*
* Copyright (c) 2014-2023 Simon Fraser University
* Copyright (c) 2000-2023 John Willinsky
* Distributed under the GNU GPL v3. For full terms see the file LICENSE.
*
* @class I35_FixMissingField
* @brief Before the version 2.0.4.3, it's needed to check for a missing "export_deposit_error" field
*/
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Capsule\Manager as Capsule;
use PKP\install\DowngradeNotSupportedException;
class I35_FixMissingField extends Migration {
/**
This file has been truncated. show original
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
trace
December 11, 2023, 4:19pm
6
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.
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
Manually
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)
Run the php lib/pkp/tools/installPluginVersion.php plugins/generic/pln/version.xml
Best,
Jonas Raoni
trace
December 19, 2023, 8:22am
8
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
trace
December 21, 2023, 10:47am
9
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