Hi,
We recently changed the encoding of our base from latin2 to utf8. Today we attempted an upgrade from ojs 3.2.1.1 to ojs 3.3.0-14.
We’ve a problem because when we try to withdraw a published article from publication (Unpublish) we get an error An unexpected error has occurred. Please reload the page and try again. And when trying to enter Quick Submit Plugin, we have HTTP500
In the logs:
Integrity constraint violation: 1062 Duplicate entry ‘0’ for key ‘PRIMARY’.
We are using php 7.4
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘0’ for key ‘PRIMARY’ (SQL: INSERT INTO data_object_tombstone_oai_set_objects\n\t\t\t\t\t(tombstone_id, assoc_type, assoc_id)\n\t\t\t\t\tVALUES\n\t\t\t\t\t(0, 530, 1))\nFile: /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php\nLine: 671\nTrace: #0 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘INSERT INTO dat…’, Array, Object(Closure))\n#1 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\Database\Connection->run(‘INSERT INTO dat…’, Array, Object(Closure))\n#2 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php(200): Illuminate\Database\Connection->affectingStatement(‘INSERT INTO dat…’, Array)\n#3 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/classes/db/DAO.inc.php(140): Illuminate\Database\Capsule\Manager::__callStatic(‘affectingStatem…’, Array)\n#4 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/classes/tombstone/DataObjectTombstoneDAO.inc.php(252): DAO->update(‘INSERT INTO dat…’, Array)\n#5 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/classes/tombstone/DataObjectTombstoneDAO.inc.php(144): DataObjectTombstoneDAO->insertOAISetObjects(Object(DataObjectTombstone))\n#6 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/classes/article/ArticleTombstoneManager.inc.php(45): DataObjectTombstoneDAO->insertObject(Object(DataObjectTombstone))\n#7 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/classes/services/SubmissionService.inc.php(58): ArticleTombstoneManager->insertArticleTombstone(Object(Submission), Object(Journal))\n#8 /home
2023-05-11 15:40:54.123727 [NOTICE] [185691] [T0] [188.47.119.63:37710-2#APVH_www.journals2.ovh.eu] [STDERR] /journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/classes/services/PKPPublicationService.inc.php(638): APP\Services\SubmissionService->updateStatus(Object(Submission))\n#9 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/api/v1/submissions/PKPSubmissionHandler.inc.php(825): PKP\Services\PKPPublicationService->unpublish(Object(Publication))\n#10 [internal function]: PKPSubmissionHandler->unpublishPublication(Object(Slim\Http\Request), Object(APIResponse), Array)\n#11 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\Http\Request), Object(APIResponse), Array)\n#12 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Slim\Http\Request), Object(APIResponse), Array)\n#13 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke(Object(Slim\Http\Request), Object(APIResponse))\n#14 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(APIResponse))\n#15 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\Route->run(Object(Slim\Http\Request), Object(APIResponse))\n#16 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.inc.php(77): Slim\App->__invoke(Object(Slim\Http\Request), Object(APIResponse))\n#17 [internal function]: ApiAuthorizationMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Slim\App))\n#18 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiAuthorizationMiddleware), Array)\n#19 [internal function]: Slim\DeferredCallable-
2023-05-11 15:40:54.123734 [NOTICE] [185691] [T0] [188.47.119.63:37710-2#APVH_www.journals2.ovh.eu] [STDERR] >__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Slim\App))\n#20 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Slim\App))\n#21 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.inc.php(46): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))\n#22 [internal function]: ApiCsrfMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))\n#23 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiCsrfMiddleware), Array)\n#24 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))\n#25 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(Closure))\n#26 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.inc.php(131): Slim\App->Slim{closure}(Object(Slim\Http\Request), Object(APIResponse))\n#27 [internal function]: ApiTokenDecodingMiddleware->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))\n#28 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiTokenDecodingMiddleware), Array)\n#29 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(APIResponse), Object(Closure))\n#30 /home/journals2/domains/journals2.ovh.eu/public_html/kcolp/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(APIResponse), Object(C
What’s at stake here.
please help me
Thanks
Janels