Describe the issue or problem
Log in as site admin and go to Administration → Hosted Journals to delete but encounter error below. This is a continuation of Cannot remove journal in OJS 3.4.0.8 multijournal installation
Steps I took leading up to the issue
For example:
- Log in as site admin
- go to Administration
- Hosted Journals
- Under Journals in drop down click on ‘Remove‘ to delete a journal but encounter error
What application are you using?
For example, OJS 3.4.0-10
Additional information
Log and screenshot:
[26-Feb-2026 14:36:24 America/Edmonton] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (cmej.review_assignments, CONSTRAINT review_assignments_review_form_id_foreign FOREIGN KEY (review_form_id) REFERENCES review_forms (review_form_id)) in server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:570
Stack trace:
#0 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): PDOStatement->execute()
#1 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database{closure}(‘DELETE FROM rev…’, Array)
#2 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback(‘DELETE FROM rev…’, Array, Object(Closure))
#3 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(558): Illuminate\Database\Connection->run(‘DELETE FROM rev…’, Array, Object(Closure))
#4 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\Database\Connection->affectingStatement(‘DELETE FROM rev…’, Array)
#5 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\Database\DatabaseManager->__call(‘affectingStatem…’, Array)
#6 server/ojs-3.4.0-10/lib/pkp/classes/db/DAO.php(179): Illuminate\Support\Facades\Facade::__callStatic(‘affectingStatem…’, Array)
#7 server/ojs-3.4.0-10/lib/pkp/classes/reviewForm/ReviewFormDAO.php(210): PKP\db\DAO->update(‘DELETE FROM rev…’, Array)
#8 server/ojs-3.4.0-10/lib/pkp/classes/reviewForm/ReviewFormDAO.php(224): PKP\reviewForm\ReviewFormDAO->deleteById(249)
#9 server/ojs-3.4.0-10/lib/pkp/classes/services/PKPContextService.php(634): PKP\reviewForm\ReviewFormDAO->deleteByAssoc(256, 102)
#10 server/ojs-3.4.0-10/lib/pkp/controllers/grid/admin/context/ContextGridHandler.php(289): PKP\services\PKPContextService->delete(Object(APP\journal\Journal))
#11 [internal function]: PKP\controllers\grid\admin\context\ContextGridHandler->deleteContext(Array, Object(APP\core\Request))
#12 server/ojs-3.4.0-10/lib/pkp/classes/core/PKPRouter.php(334): call_user_func(Array, Array, Object(APP\core\Request))
#13 server/ojs-3.4.0-10/lib/pkp/classes/core/PKPComponentRouter.php(291): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array)
#14 server/ojs-3.4.0-10/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPComponentRouter->route(Object(APP\core\Request))
#15 server/ojs-3.4.0-10/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch(Object(APP\core\Request))
#16 server/ojs-3.4.0-10/index.php(21): PKP\core\PKPApplication->execute()
#17 {main}
Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (cmej.review_assignments, CONSTRAINT review_assignments_review_form_id_foreign FOREIGN KEY (review_form_id) REFERENCES review_forms (review_form_id)) (SQL: DELETE FROM review_forms WHERE review_form_id = 249) in server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback(‘DELETE FROM rev…’, Array, Object(Closure))
#1 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(558): Illuminate\Database\Connection->run(‘DELETE FROM rev…’, Array, Object(Closure))
#2 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\Database\Connection->affectingStatement(‘DELETE FROM rev…’, Array)
#3 server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\Database\DatabaseManager->__call(‘affectingStatem…’, Array)
#4 server/ojs-3.4.0-10/lib/pkp/classes/db/DAO.php(179): Illuminate\Support\Facades\Facade::__callStatic(‘affectingStatem…’, Array)
#5 server/ojs-3.4.0-10/lib/pkp/classes/reviewForm/ReviewFormDAO.php(210): PKP\db\DAO->update(‘DELETE FROM rev…’, Array)
#6 server/ojs-3.4.0-10/lib/pkp/classes/reviewForm/ReviewFormDAO.php(224): PKP\reviewForm\ReviewFormDAO->deleteById(249)
#7 server/ojs-3.4.0-10/lib/pkp/classes/services/PKPContextService.php(634): PKP\reviewForm\ReviewFormDAO->deleteByAssoc(256, 102)
#8 server/ojs-3.4.0-10/lib/pkp/controllers/grid/admin/context/ContextGridHandler.php(289): PKP\services\PKPContextService->delete(Object(APP\journal\Journal))
#9 [internal function]: PKP\controllers\grid\admin\context\ContextGridHandler->deleteContext(Array, Object(APP\core\Request))
#10 server/ojs-3.4.0-10/lib/pkp/classes/core/PKPRouter.php(334): call_user_func(Array, Array, Object(APP\core\Request))
#11 server/ojs-3.4.0-10/lib/pkp/classes/core/PKPComponentRouter.php(291): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array)
#12 server/ojs-3.4.0-10/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPComponentRouter->route(Object(APP\core\Request))
#13 server/ojs-3.4.0-10/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch(Object(APP\core\Request))
#14 server/ojs-3.4.0-10/index.php(21): PKP\core\PKPApplication->execute()
#15 {main}
thrown in server/ojs-3.4.0-10/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760
[26-Feb-2026 14:38:16 America/Edmonton] Missing locale key “search.searchResults.foundPlural” for the locale “en”
[26-Feb-2026 14:39:27 America/Edmonton] ojs2: 404 Not Found
[26-Feb-2026 14:39:57 America/Edmonton] PHP Deprecated: json_decode(): Passing null to parameter #1 ($json) of type string is deprecated in server/ojs-3.4.0-10/plugins/generic/citations/CitationsPlugin.php on line 68
[26-Feb-2026 14:40:28 America/Edmonton] ojs2: 404 Not Found
[26-Feb-2026 14:41:34 America/Edmonton] ojs2: 404 Not Found
[26-Feb-2026 14:42:10 America/Edmonton] ojs2: 404 Not Found
[26-Feb-2026 14:42:12 America/Edmonton] PHP Deprecated: json_decode(): Passing null to parameter #1 ($json) of type string is deprecated in server/ojs-3.4.0-10/plugins/generic/citations/CitationsPlugin.php on line 68
[26-Feb-2026 14:42:43 America/Edmonton] ojs2: 404 Not Found




