Error in displaying Editorial Masthead in browser Upgraded from 3.4.0.9 to 3.5.0.1

Software Support
,
1

https://kkla.in/journal/index.php/jimet/about/editorialMasthead shows kkla.in can’t currently handle this request.
HTTP ERROR 500

thrown in /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 825

Following is the complete error description
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘u.user_id’ in ‘on clause’ in /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407 Stack trace: #0 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): PDO->prepare(‘select u., ...') #1 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}('select u.*, …', Array) #2 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback('select u., ...', Array, Object(Closure)) #3 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run('select u.*, …’, Array, Object(Closure)) #4 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\Database\Connection->select(‘select u., ...', Array, true) #5 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\Database\Query\Builder->runSelect() #6 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #7 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #8 /home4/kklaimki/public_html/journal/lib/pkp/classes/userGroup/Repository.php(584): Illuminate\Database\Query\Builder->get() #9 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(427): PKP\userGroup\Repository->PKP\userGroup\{closure}() #10 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(453): Illuminate\Cache\Repository->remember('PKP\\userGroup\\R...', Object(DateInterval), Object(Closure)) #11 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Cache\CacheManager->__call('remember', Array) #12 /home4/kklaimki/public_html/journal/lib/pkp/classes/userGroup/Repository.php(561): Illuminate\Support\Facades\Facade::__callStatic('remember', Array) #13 /home4/kklaimki/public_html/journal/lib/pkp/pages/about/AboutContextHandler.php(99): PKP\userGroup\Repository->getMastheadUserIdsByRoleIds(Array, 1) #14 [internal function]: PKP\pages\about\AboutContextHandler->editorialMasthead(Array, Object(APP\core\Request)) #15 /home4/kklaimki/public_html/journal/lib/pkp/classes/core/PKPRouter.php(327): call_user_func(Array, Array, Object(APP\core\Request)) #16 /home4/kklaimki/public_html/journal/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false) #17 /home4/kklaimki/public_html/journal/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route(Object(APP\core\Request)) #18 /home4/kklaimki/public_html/journal/lib/pkp/classes/core/PKPApplication.php(426): PKP\core\Dispatcher->dispatch(Object(APP\core\Request)) #19 /home4/kklaimki/public_html/journal/index.php(21): PKP\core\PKPApplication->execute() #20 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.user_id' in 'on clause' (Connection: mysql, SQL: select u.*, uugob.user_group_idfromusersasuleft joinuser_user_groupsasuugobonuugob.user_id=u.user_idwhereu.disabled= 0 and exists (select * fromuser_user_groupsasuuginner joinuser_groupsasugonuug.user_group_id=ug.user_group_idwhereuug.user_id=u.user_idanduug.user_group_id in (3, 19, 5) and COALESCE(ug.context_id, 0) in (1) and (uug.date_start<= 2025-07-21 12:46:03 oruug.date_start is null) and (uug.date_end> 2025-07-21 12:46:03 oruug.date_endis null) andug.masthead= 1 anduug.masthead= 1) order by FIELD(uugob.user_group_id, 3, 19, 5) ASC, (select CONCAT(COALESCE(us_0_0.setting_value, ''), COALESCE(us_1_0.setting_value, '')) from (select 0) asplaceholderleft joinuser_settingsasus_0_0onus_0_0.user_id=u.user_idandus_0_0.setting_name= familyName andus_0_0.locale= en left joinuser_settingsasus_1_0onus_1_0.user_id=u.user_idandus_1_0.setting_name= givenName andus_1_0.locale= en) asc) in /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825 Stack trace: #0 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback('selectu.*, …', Array, Object(Closure)) #1 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run('select u., ...', Array, Object(Closure)) #2 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\Database\Connection->select('select u.*, …’, Array, true) #3 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\Database\Query\Builder->runSelect() #4 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}() #5 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /home4/kklaimki/public_html/journal/lib/pkp/classes/userGroup/Repository.php(584): Illuminate\Database\Query\Builder->get() #7 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(427): PKP\userGroup\Repository->PKP\userGroup{closure}() #8 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(453): Illuminate\Cache\Repository->remember(‘PKP\userGroup\R…’, Object(DateInterval), Object(Closure)) #9 /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Cache\CacheManager->__call(‘remember’, Array) #10 /home4/kklaimki/public_html/journal/lib/pkp/classes/userGroup/Repository.php(561): Illuminate\Support\Facades\Facade::__callStatic(‘remember’, Array) #11 /home4/kklaimki/public_html/journal/lib/pkp/pages/about/AboutContextHandler.php(99): PKP\userGroup\Repository->getMastheadUserIdsByRoleIds(Array, 1) #12 [internal function]: PKP\pages\about\AboutContextHandler->editorialMasthead(Array, Object(APP\core\Request)) #13 /home4/kklaimki/public_html/journal/lib/pkp/classes/core/PKPRouter.php(327): call_user_func(Array, Array, Object(APP\core\Request)) #14 /home4/kklaimki/public_html/journal/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(APP\core\Request), Array, false) #15 /home4/kklaimki/public_html/journal/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route(Object(APP\core\Request)) #16 /home4/kklaimki/public_html/journal/lib/pkp/classes/core/PKPApplication.php(426): PKP\core\Dispatcher->dispatch(Object(APP\core\Request)) #17 /home4/kklaimki/public_html/journal/index.php(21): PKP\core\PKPApplication->execute() #18 {main} thrown in /home4/kklaimki/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 825

Upgraded from OJS 3.4.0.9 to 3.5.0.1

Please help me.

2

Hi, I received the same error. I don’t use this functionality at all, and to fix I linked Editorial Masthead (or whatever name you use for this) in Navigation Menu Items with Custom Page instead of Editorial Masthead.

3

Please tell me the steps to follow

4

Thank you ,… Got the solution

5

I’ve found that the blocking factor in upgrading from OJS 3.4.0.9 to OJS 3.5.0.1 is the structure of some tables in the new database. A key one is in the users table. The new table has 22 columns, while the old one had 21. The remember_token varchar(100) utf8mb4_general_ci Yes NULL column needs to be inserted. The gossip column also needs to be moved to position 11.

6

Hi @jhisaza,

The upgrade scripts should make any necessary changes to your database schema. I don’t recommend trying to make these changes manually!

Regards,
Alec Smecher
Public Knowledge Project Team

7

I had the same issue, and I fixed it by upgrading to MySQL 8 or MariaDB 10 or a newer version

8

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