The PKP PN plugin has been “in progress” for a month now.
Error message
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 MySQL server version for the right syntax to use near ＇as do where do.journal_id not in (select j.journal_id from journals ＇ at line 1 in /www/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:566\nStack trace:\n#0 /www/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(566): PDO-＞prepare()\n#1 /www/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection-＞Illuminate\Database\{closure}()\n#2 /www/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection-＞runQueryCallback()\n#3 /www/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(577):…＇
Other logs
scheduledTaskLogs/PKPPNDepositorTask-XXX.log
[2024-08-03 05:00:06] [Notice] Task process started.
[2024-08-03 05:00:06] [Notice] PKP Preservation Network Processor
[2024-08-03 05:00:06] [Notice] Depositor processing for XXX.
[2024-08-03 05:00:06] [Notice] Getting service document.
[2024-08-03 05:00:07] [Notice] Processing new content.
[2024-08-03 05:00:07] [Notice] Processing updated content.
[2024-08-03 05:00:07] [Notice] Packaging content for deposit.
[2024-08-03 05:00:07] [Notice] Processing deposit status updates.
[2024-08-03 05:00:07] [Notice] Trying status update for 4 (Issue: 4) (Local Status: [Transferred], Processing Status: [Unknown], Lockss Status: [Unknown])
[2024-08-03 05:00:09] [Notice] Processing status got for 4 → (depositedByJournal)
[2024-08-03 05:00:09] [Notice] Sending deposits to the PKP PN.
[2024-08-03 05:00:09] [Notice] Pruning orphaned deposits.
What’s the URL of your journal? I guess you’re using MariaDB as your database, right?
I just can say this error shouldn’t be interrupting the process from completing, it’s happening at the last step, where the plugin just does a small cleanup.
The URL of our journal is indeed https://gafj.org
Same as the other articles.
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.
We appreciate your interest and support.
You had exactly the same issue as in the other post. The server failed to download the deposit too many times, and assumed that it’s not working.
There was a network issue on the server, which probably lead to this problem. Yesterday I reset all the failed deposits, your deposit is now in progress (it just passed through the virus checker), but it should take a couple of days until it’s over.
The error code still runs every day, and the status is still ‘in progress’.
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 MySQL server version for the right syntax to use near ＇as do where do.journal_id not in (select j.journal_id from journals ＇ at line 1 in /www/wwwroot/gafj.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:566\nStack trace:\n#0 /www/wwwroot/gafj.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(566): PDO-＞prepare()\n#1 /www/wwwroot/gafj.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection-＞Illuminate\Database\{closure}()\n#2 /www/wwwroot/gafj.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection-＞runQueryCallback()\n#3 /www/wwwroot/gafj.org/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(577):…＇
[2024-08-13 05:26:55] http://gafj.org
[2024-08-13 05:26:55] [Notice] Task process started.
[2024-08-13 05:26:55] [Notice] PKP Preservation Network Processor
[2024-08-13 05:26:55] [Notice] Depositor processing for Global Academic Frontiers.
[2024-08-13 05:26:55] [Notice] Getting service document.
[2024-08-13 05:26:56] [Notice] Processing new content.
[2024-08-13 05:26:56] [Notice] Processing updated content.
[2024-08-13 05:26:56] [Notice] Packaging content for deposit.
[2024-08-13 05:26:56] [Notice] Processing deposit status updates.
[2024-08-13 05:26:56] [Notice] Trying status update for 4 (Issue: 4) (Local Status: [Transferred], Processing Status: [Sent to LOCKSS], Lockss Status: [Received])
[2024-08-13 05:26:58] [Notice] Processing status got for 4 → (deposited)
[2024-08-13 05:26:58] [Notice] Sending deposits to the PKP PN.
[2024-08-13 05:26:58] [Notice] Pruning orphaned deposits.
The error is not a blocker, I’ll get it fixed in a couple of days. See the status changed from Processing status got for 4 → (depositedByJournal) to Processing status got for 4 → (deposited).
I’ve just checked the status in the system and it’s completed, once the plugin grab the updates, you should see the same status on your end.
Hi, just want to confirm that we have the same problem with one of our journal (Psycause) using the plugin PKP PN. All issues never quit the “In progress” statut even if we try to Resubmit (last attempt was a week ago or so). We are on OJS 3.4 and use the more recent version of the plugin. Thanks for you help! Best, Pierre