I am OJS manager and responsible for everything that can be done on the user interface (not the server), journal management, user management, website style, …
When trying to remove an old journal we used for testing and reviewing galley files in our multijournal installation, it did not work. In administration → site management → hosted journals I removed all users but one (the admin account) from the journal in question and then clicked on “remove” to delete the journal and all its content. The window for confirmation opened and I clicked ‘ok’ but nothing happened. The error log shows:
[Mon Feb 17 09:34:19.469631 2025] [proxy_fcgi:error] [pid 1317441:tid 139749851027008] [remote IP redacted] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (ojs.authors, CONSTRAINT authors_user_group_id_foreign FOREIGN KEY (user_group_id) REFERENCES user_groups (user_group_id)) in /var/www/redacted/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:570\nStack trace:\n#0 /var/www/redacted/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): PDOStatement->execute()\n#1 /var/www/redacted/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()\n#2 /var/www/redacted/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()\n#3 /var/www/redacted/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(5…’, referer: https://redacted/index.php/index/admin/contexts
What can I do to fix this?
We use OJS 3.4.0.8 that was recently upgraded from OJS 3.3.0.8 (started out as 2.2.3.0 in 2009 and went through several upgrades since)
multijournal installation (7 active journals + 3 hidden journals for internal use only)
PHP version 8.3.16