PKP PN Plugin Fatal error (OJS 3.4.0.5)

[seisense]

I have installed the latest version of PKP PN Plugin from within the OJS plugin gallery and receiving the following fatal errors:

[09-May-2024 12:10:07 Asia/Riyadh] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘as do where do.journal_id not in (select j.journal_id from `journal…’ at line 1 in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:566
Stack trace:
#0 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(566): PDO->prepare()
#1 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database{closure}()
#2 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(577): Illuminate\Database\Connection->run()
#4 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(522): Illuminate\Database\Connection->affectingStatement()
#5 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3552): Illuminate\Database\Connection->delete()
#6 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/depositObject/DAO.php(256): Illuminate\Database\Query\Builder->delete()
#7 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/depositObject/Repository.php(258): APP\plugins\generic\pln\classes\depositObject\DAO->pruneOrphaned()
#8 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/tasks/Depositor.php(308): APP\plugins\generic\pln\classes\depositObject\Repository->pruneOrphaned()
#9 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/tasks/Depositor.php(148): APP\plugins\generic\pln\classes\tasks\Depositor->pruneOrphaned()
#10 /home/seisense/journal.seisense.com/lib/pkp/classes/scheduledTask/ScheduledTask.php(165): APP\plugins\generic\pln\classes\tasks\Depositor->executeActions()
#11 /home/seisense/journal.seisense.com/plugins/generic/acron/AcronPlugin.php(281): PKP\scheduledTask\ScheduledTask->execute()
#12 /home/seisense/journal.seisense.com/plugins/generic/acron/AcronPlugin.php(195): APP\plugins\generic\acron\AcronPlugin->_shutdownFunction()
#13 [internal function]: APP\plugins\generic\acron\AcronPlugin->APP\plugins\generic\acron{closure}()
#14 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'as do where do.journal_id not in (select j.journal_id from journal...' at line 1 (SQL: delete from pln_deposit_objectsasdowheredo.journal_idnot in (selectj.journal_idfromjournalsasj) or do.deposit_idnot in (selectd.deposit_idfrompln_depositsasd`)) in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(577): Illuminate\Database\Connection->run()
#2 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(522): Illuminate\Database\Connection->affectingStatement()
#3 /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3552): Illuminate\Database\Connection->delete()
#4 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/depositObject/DAO.php(256): Illuminate\Database\Query\Builder->delete()
#5 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/depositObject/Repository.php(258): APP\plugins\generic\pln\classes\depositObject\DAO->pruneOrphaned()
#6 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/tasks/Depositor.php(308): APP\plugins\generic\pln\classes\depositObject\Repository->pruneOrphaned()
#7 /home/seisense/journal.seisense.com/plugins/generic/pln/classes/tasks/Depositor.php(148): APP\plugins\generic\pln\classes\tasks\Depositor->pruneOrphaned()
#8 /home/seisense/journal.seisense.com/lib/pkp/classes/scheduledTask/ScheduledTask.php(165): APP\plugins\generic\pln\classes\tasks\Depositor->executeActions()
#9 /home/seisense/journal.seisense.com/plugins/generic/acron/AcronPlugin.php(281): PKP\scheduledTask\ScheduledTask->execute()
#10 /home/seisense/journal.seisense.com/plugins/generic/acron/AcronPlugin.php(195): APP\plugins\generic\acron\AcronPlugin->_shutdownFunction()
#11 [internal function]: APP\plugins\generic\acron\AcronPlugin->APP\plugins\generic\acron{closure}()
#12 {main}
thrown in /home/seisense/journal.seisense.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760

OJS 3.4.0.5
PHP: 8.1

Please help me solve this error
Thanks
seisense

[seisense]

Hi,
I am still struggling to fix this problem. Everyday PKP PN plugin latest update column changes to current date but status remain “in progress”. And PHP fatal error above also appearing every day once in the PHP error log.

Anyone have the idea where should I look at to fix this problem.
Thanks
seisense

[GAF]

I also have the same error code, the pkp pn status remains’ in progress’ every day

[jonasraoni]

Hi @seisense,

Your deposit appears in progress because the server desisted to download your deposit after trying a couple of times. I’ll reset it.

Best,
Jonas Raoni

[jonasraoni]

Done! Anyway, it will take a couple of days until it gets preserved.

Best,
Jonas Raoni