OJS 3.4.0-4 Slim Application Error

After upgrading to version 3.4.0-4, when trying to upload new files during the submission process, we get an “Slim Application Error”

Here is some relevant output from the error log:

[Fri Feb 02 10:14:33.678478 2024] [php:notice] [pid 79401] [client 10.0.0.116:49376] Slim Application Error:\nType: Illuminate\Database\QueryException\nCode: 42S22\nMessage: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'locale' in 'field list' (SQL: insert into event_log_settings (log_id, locale, setting_name, setting_value) values (55873, de, filename, Aufrufzahlen_Cambridge_2.PNG))\nFile: /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php\nLine: 760\nTrace: #0 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()\n#1 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()\n#2 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()\n#3 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()\n#4 /opt/ojs-obib/lib/pkp/classes/core/EntityDAO.php(166): Illuminate\Database\Query\Builder->insert()\n#5 /opt/ojs-obib/lib/pkp/classes/log/event/DAO.php(151): PKP\core\EntityDAO->_insert()\n#6 /opt/ojs-obib/lib/pkp/classes/log/event/Repository.php(121): PKP\log\event\DAO->insert()\n#7 /opt/ojs-obib/lib/pkp/classes/submissionFile/Repository.php(506): PKP\log\event\Repository->add()\n#8 /opt/ojs-obib/classes/submissionFile/Repository.php(62): PKP\submissionFile\Repository->delete()\n#9 /opt/ojs-obib/lib/pkp/api/v1/submissions/PKPSubmissionFileHandler.php(547): APP\submissionFile\Repository->delete()\n#10 [internal function]: PKP\API\v1\submissions\PKPSubmissionFileHandler->delete()\n#11 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func()\n#12 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke()\n#13 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke()\n#14 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack()\n#15 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\Route->run()\n#16 /opt/ojs-obib/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.php(90): Slim\App->__invoke()\n#17 [internal function]: PKP\security\authorization\internal\ApiAuthorizationMiddleware->__invoke()\n#18 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()\n#19 [internal function]: Slim\DeferredCallable->__invoke()\n#20 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()\n#21 /opt/ojs-obib/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.php(56): Slim\App->Slim\{closure}()\n#22 [internal function]: PKP\security\authorization\internal\ApiCsrfMiddleware->__invoke()\n#23 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()\n#24 [internal function]: Slim\DeferredCallable->__invoke()\n#25 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()\n#26 /opt/ojs-obib/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.php(140): Slim\App->Slim\{closure}()\n#27 [internal function]: PKP\security\authorization\internal\ApiTokenDecodingMiddleware->__invoke()\n#28 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()\n#29 [internal function]: Slim\DeferredCallable->__invoke()\n#30 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()\n#31 /opt/ojs-obib/lib/pkp/classes/handler/APIHandler.php(83): Slim\App->Slim\{closure}()\n#32 [internal function]: PKP\handler\APIHandler->PKP\handler\{closure}()\n#33 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()\n#34 [internal function]: Slim\DeferredCallable->__invoke()\n#35 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()\n#36 /opt/ojs-obib/lib/pkp/classes/handler/APIHandler.php(100): Slim\App->Slim\{closure}()\n#37 [internal function]: PKP\handler\APIHandler->PKP\handler\{closure}()\n#38 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()\n#39 [internal function]: Slim\DeferredCallable->__invoke()\n#40 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()\n#41 /opt/ojs-obib/lib/pkp/classes/handler/APIHandler.php(105): Slim\App->Slim\{closure}()\n#42 [internal function]: PKP\handler\APIHandler->PKP\handler\{closure}()\n#43 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()\n#44 [internal function]: Slim\DeferredCallable->__invoke()\n#45 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()\n#46 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}()\n#47 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack()\n#48 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/App.php(297): Slim\App->process()\n#49 /opt/ojs-obib/lib/pkp/classes/core/APIRouter.php(110): Slim\App->run()\n#50 /opt/ojs-obib/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\APIRouter->route()\n#51 /opt/ojs-obib/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch()\n#52 /opt/ojs-obib/index.php(21): PKP\core\PKPApplication->execute()\n#53 {main}\nPrevious error:\nType: PDOException\nCode: 42S22\nMessage: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'locale' in 'field list'\nFile: /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php\nLine: 539\nTrace: #0 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(539): PDO->prepare()\n#1 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()\n#2 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()\n#3 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()\n#4 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()\n#5 /opt/ojs-obib/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()\n#6 /opt/ojs-obib/lib/pkp/classes/core/EntityDAO.php(166): Illuminate\Database\Query\Builder->insert()\n#7 /opt/ojs-obib/lib/pkp/classes/log/event/DAO.php(151): PKP\core\EntityDAO->_insert()\n#8 /opt/ojs-obib/lib/pkp/classes/log/event/Repository.php(121): PKP\log\event\DAO->insert()\n#9 /opt/ojs-obib/lib/pkp/classes/submissionFile/Repository.php(506): PKP\log\event\Repository->add()\n#10 /opt/ojs-obib/classes/submissionFile/Repository.php(62): PKP\submissionFile\Repository->delete()\n#11 /opt/ojs-obib/lib/pkp/api/v1/submissions/PKPSubmissionFileHandler.php(547): APP\submissionFile\Repository->delete()\n#12 [internal function]: PKP\API\v1\submissions\PKPSubmissionFileHandler->delete()\n#13 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func()\n#14 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke()\n#15 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke()\n#16 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack()\n#17 /opt/ojs-obib/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\Rou

1 Like

Hi @zieglcar,

Can you double-check what version OJS reports you are using? You can do this with any of the following…

  • Running php tools/upgrade.php check on the command line
  • Going to Administration > System Information
  • Viewing the page source and looking for the “generator” meta tag

Regards,
Alec Smecher
Public Knowledge Project Team

Hi Alec Smecher,

it is version 3.4.0-4.

Regards,
Caroline

Hi @zieglcar,

Can you confirm that OJS itself reports 3.4.0-4 via one of the means above? Even if you’ve used the 3.4.0-4 .tar.gz file, it’s important to know what version OJS thinks it is.

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher,

I checked already by going to Administration > System Information:

Regards,
Caroline

This topic was automatically closed after 9 days. New replies are no longer allowed.