PKP PN fatal error (in progress)

Software Support
1

Hi @jonasraoni ,
Unfortunately, I have to open this issue once again

After waiting for three weeks, SJOM Vol 4 no 4 is still showing “in progress” and following error appear in php error log every day as well:

[26-Aug-2024 14:37:02 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(558): 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(3550): 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(558): 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(3550): 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

Problem is with this specific issue only. All other issues before and after are deposited successfully

image
image1574×1355 205 KB

Hope you will investigate and help me fixing this problem.
Thanks
seisense