Dear PKP Support,
When I want to clear a signed DOI in Issue, I get an error message like below:
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 'ps\n\t\t\t\tWHERE ps.publication_id = ?\n\t\t\t\tAND ps.setting_name= ?' at line 1 in /var/www/html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): PDO->prepare()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(485): Doctrine\\DBAL\\Driver\\PDOConnection->prepare()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()\n#3 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()\n#4 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run()\n#5 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement()\n#6 /var/www/html/lib/pkp/classes/db/DAO.inc.php(145): Illuminate\\Database\\Capsule\\Manager::__callStatic()\n#7 /var/www/html/lib/pkp/classes/publication/PKPPublicationDAO.inc.php(273): DAO->update()\n#8 /var/www/html/classes/plugins/PubIdPlugin.inc.php(278): PKPPublicationDAO->deletePubId()\n#9 /var/www/html/controllers/tab/pubIds/form/PublicIdentifiersForm.inc.php(65): PubIdPlugin->clearIssueObjectsPubIds()\n#10 /var/www/html/classes/controllers/grid/issues/IssueGridHandler.inc.php(394): PublicIdentifiersForm->clearIssueObjectsPubIds()\n#11 /var/www/html/lib/pkp/classes/core/PKPRouter.inc.php(397): IssueGridHandler->clearIssueObjectsPubIds()\n#12 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest()\n#13 /var/www/html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route()\n#14 /var/www/html/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch()\n#15 /var/www/html/index.php(68): PKPApplication->execute()\n#16 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDO\\Exception: 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 'ps\n\t\t\t\tWHERE ps.publication_id = ?\n\t\t\t\tAND ps.setting_name= ?' at line 1 in /var/www/html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(85): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(485): Doctrine\\DBAL\\Driver\\PDOConnection->prepare()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()\n#3 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()\n#4 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run()\n#5 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement()\n#6 /var/www/html/lib/pkp/classes/db/DAO.inc.php(145): Illuminate\\Database\\Capsule\\Manager::__callStatic()\n#7 /var/www/html/lib/pkp/classes/publication/PKPPublicationDAO.inc.php(273): DAO->update()\n#8 /var/www/html/classes/plugins/PubIdPlugin.inc.php(278): PKPPublicationDAO->deletePubId()\n#9 /var/www/html/controllers/tab/pubIds/form/PublicIdentifiersForm.inc.php(65): PubIdPlugin->clearIssueObjectsPubIds()\n#10 /var/www/html/classes/controllers/grid/issues/IssueGridHandler.inc.php(394): PublicIdentifiersForm->clearIssueObjectsPubIds()\n#11 /var/www/html/lib/pkp/classes/core/PKPRouter.inc.php(397): IssueGridHandler->clearIssueObjectsPubIds()\n#12 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest()\n#13 /var/www/html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route()\n#14 /var/www/html/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch()\n#15 /var/www/html/index.php(68): PKPApplication->execute()\n#16 {main}\n\nNext 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 MySQL server version for the right syntax to use near 'ps\n\t\t\t\tWHERE ps.publication_id = ?\n\t\t\t\tAND ps.setting_name= ?' at line 1 (SQL: DELETE FROM publication_settings ps\n\t\t\t\tWHERE ps.publication_id = 1254\n\t\t\t\tAND ps.setting_name= pub-id::doi) in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\\Database\\Connection->run()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\\Database\\Connection->affectingStatement()\n#3 /var/www/html/lib/pkp/classes/db/DAO.inc.php(145): Illuminate\\Database\\Capsule\\Manager::__callStatic()\n#4 /var/www/html/lib/pkp/classes/publication/PKPPublicationDAO.inc.php(273): DAO->update()\n#5 /var/www/html/classes/plugins/PubIdPlugin.inc.php(278): PKPPublicationDAO->deletePubId()\n#6 /var/www/html/controllers/tab/pubIds/form/PublicIdentifiersForm.inc.php(65): PubIdPlugin->clearIssueObjectsPubIds()\n#7 /var/www/html/classes/controllers/grid/issues/IssueGridHandler.inc.php(394): PublicIdentifiersForm->clearIssueObjectsPubIds()\n#8 /var/www/html/lib/pkp/classes/core/PKPRouter.inc.php(397): IssueGridHandler->clearIssueObjectsPubIds()\n#9 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest()\n#10 /var/www/html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPComponentRouter->route()\n#11 /var/www/html/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch()\n#12 /var/www/html/index.php(68): PKPApplication->execute()\n#13 {main}\n thrown in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671, referer: https://proceedings.ums.ac.id/iseth/manageIssues
I am using OJS version 3.3.0-20
Best regards.