OJS 3.4.0-4 Slim Application Error

zieglcar · February 2, 2024, 9:38am

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

asmecher · February 2, 2024, 6:11pm

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

zieglcar · February 5, 2024, 7:01am

Hi Alec Smecher,

it is version 3.4.0-4.

Regards,
Caroline

asmecher · February 5, 2024, 3:30pm

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

zieglcar · February 7, 2024, 7:48am

Hi @asmecher,

I checked already by going to Administration > System Information:

Regards,
Caroline

asmecher · February 12, 2024, 4:00pm

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

Farooq_Baig · April 26, 2024, 6:26pm

Dear Alec Smecher
I have installed 3.4.0.5 Just some minutes ago and I am facing the same problem i.e SLIM APPLICATION ERROR.

Farooq_Baig · April 26, 2024, 6:27pm

zieglcar · April 29, 2024, 8:01am

@Farooq_Baig At my end, the error ceased to occur after I reset my installation to OJS 3.3.0-14 and then proceeded directly to upgrade to version 3.4.0-5. Previously, I had performed several interim upgrades between these two versions.

LAIPENG · October 17, 2024, 3:01am

I had the same issue on this operation,if i set the ‘Comments for the Editor’ then trigger this error else all be fine,my OJS version is 3.4.0.4 .had u solved this problem?

pdti_unira · January 8, 2025, 2:51am

Last month it was still possible to upload files to OJS v3.4.0.5, but in recent days we have experienced something similar “Slim Application Error” even though we haven’t made any changes.
Has anyone on this forum managed to solve this problem? especially those who are on OJS v3.4.0.5.
from several articles we read regarding fileinfo which is not active on the server, but when we checked the file was active from the start when we installed ojs

asmecher · January 8, 2025, 4:21pm

Hi all,

The general message “Slim Application Error” could mean many things. The way to check out what specific message you’re dealing with is to look into the PHP error log (How do I find my PHP error log? - #3 by asmecher) and find the details. Please post them as a new topic and the team will do what they can to help.

Regards,
Alec Smecher
Public Knowledge Project Team