Open yancho opened 7 months ago
This is a new 3.4.0-5 installation. Trying to play around with it and got this error in error.log when searching for a reviewer
[Mon Mar 04 21:21:24.374135 2024] [php:error] [pid 19] [client 192.168.176.1:36534] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.user_id' in 'where clause' in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): PDO->prepare()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()\n#3 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()\n#4 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()\n#5 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()\n#6 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#7 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()\n#8 /var/www/html/lib/pkp/classes/user/DAO.php(125): Illuminate\\Database\\Query\\Builder->get()\n#9 /var/www/html/lib/pkp/classes/user/Collector.php(97): PKP\\user\\DAO->getMany()\n#10 /var/www/html/lib/pkp/classes/controllers/grid/users/reviewer/PKPReviewerGridHandler.php(480): PKP\\user\\Collector->getMany()\n#11 [internal function]: PKP\\controllers\\grid\\users\\reviewer\\PKPReviewerGridHandler->getUsersNotAssignedAsReviewers()\n#12 /var/www/html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()\n#13 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.php(291): PKP\\core\\PKPRouter->_authorizeInitializeAndCallRequest()\n#14 /var/www/html/lib/pkp/classes/core/Dispatcher.php(165): PKP\\core\\PKPComponentRouter->route()\n#15 /var/www/html/lib/pkp/classes/core/PKPApplication.php(388): PKP\\core\\Dispatcher->dispatch()\n#16 /var/www/html/index.php(21): PKP\\core\\PKPApplication->execute()\n#17 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.user_id' in 'where clause' (SQL: selectu.* fromusersasuwhereu.disabled= 0 and exists (select * fromuser_user_groupsasuuginner joinuser_groupsasugonuug.user_group_id=ug.user_group_idleft join (selectuug.user_idfromuser_user_groupsasuuginner joinuser_groupsasugonuug.user_group_id=ug.user_group_idwhereuug.user_id=u.user_idandug.context_idin (1) andug.role_idin (4096)) asagronuug.user_id=agr.user_idwhereuug.user_id=u.user_idandug.context_idin (1) andagr.user_idis null) and (LOWER(u.username) LIKE LOWER(%abcdefghijklmnopqrstuv@g%) or LOWER(u.email) LIKE LOWER(%mpulis@g%) or exists (select * fromuser_settingsasuswhereus.user_id=u.user_idandus.setting_namein (givenName, familyName, preferredPublicName, affiliation, biography, orcid) and LOWER(us.setting_value) LIKE LOWER(%abcdefghijklmnopqrstuv@g%)) or exists (select * fromuser_interestsasuiinner joincontrolled_vocab_entry_settingsascvesonui.controlled_vocab_entry_id=cves.controlled_vocab_entry_idwhereui.user_id=u.user_idand LOWER(cves.setting_value) LIKE LOWER(%mpulis@g%))) order byu.user_idasc) in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()\n#3 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()\n#4 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#5 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()\n#6 /var/www/html/lib/pkp/classes/user/DAO.php(125): Illuminate\\Database\\Query\\Builder->get()\n#7 /var/www/html/lib/pkp/classes/user/Collector.php(97): PKP\\user\\DAO->getMany()\n#8 /var/www/html/lib/pkp/classes/controllers/grid/users/reviewer/PKPReviewerGridHandler.php(480): PKP\\user\\Collector->getMany()\n#9 [internal function]: PKP\\controllers\\grid\\users\\reviewer\\PKPReviewerGridHandler->getUsersNotAssignedAsReviewers()\n#10 /var/www/html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()\n#11 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.php(291): PKP\\core\\PKPRouter->_authorizeInitializeAndCallRequest()\n#12 /var/www/html/lib/pkp/classes/core/Dispatcher.php(165): PKP\\core\\PKPComponentRouter->route()\n#13 /var/www/html/lib/pkp/classes/core/PKPApplication.php(388): PKP\\core\\Dispatcher->dispatch()\n#14 /var/www/html/index.php(21): PKP\\core\\PKPApplication->execute()\n#15 {main}\n thrown in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760, referer: https://ojs.abcdefghijklmnopqrstuv.stream/index.php/de/workflow/index/8/3
[Mon Mar 04 21:21:24.374135 2024] [php:error] [pid 19] [client 192.168.176.1:36534] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.user_id' in 'where clause' in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): PDO->prepare()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()\n#3 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()\n#4 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()\n#5 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()\n#6 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#7 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()\n#8 /var/www/html/lib/pkp/classes/user/DAO.php(125): Illuminate\\Database\\Query\\Builder->get()\n#9 /var/www/html/lib/pkp/classes/user/Collector.php(97): PKP\\user\\DAO->getMany()\n#10 /var/www/html/lib/pkp/classes/controllers/grid/users/reviewer/PKPReviewerGridHandler.php(480): PKP\\user\\Collector->getMany()\n#11 [internal function]: PKP\\controllers\\grid\\users\\reviewer\\PKPReviewerGridHandler->getUsersNotAssignedAsReviewers()\n#12 /var/www/html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()\n#13 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.php(291): PKP\\core\\PKPRouter->_authorizeInitializeAndCallRequest()\n#14 /var/www/html/lib/pkp/classes/core/Dispatcher.php(165): PKP\\core\\PKPComponentRouter->route()\n#15 /var/www/html/lib/pkp/classes/core/PKPApplication.php(388): PKP\\core\\Dispatcher->dispatch()\n#16 /var/www/html/index.php(21): PKP\\core\\PKPApplication->execute()\n#17 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.user_id' in 'where clause' (SQL: select
.* from
as
where
.
= 0 and exists (select * from
inner join
on
=
left join (select
from
and
in (1) and
in (4096)) as
is null) and (LOWER(u.username) LIKE LOWER(%abcdefghijklmnopqrstuv@g%) or LOWER(u.email) LIKE LOWER(%mpulis@g%) or exists (select * from
in (givenName, familyName, preferredPublicName, affiliation, biography, orcid) and LOWER(us.setting_value) LIKE LOWER(%abcdefghijklmnopqrstuv@g%)) or exists (select * from
and LOWER(cves.setting_value) LIKE LOWER(%mpulis@g%))) order by
asc) in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()\n#3 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()\n#4 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#5 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()\n#6 /var/www/html/lib/pkp/classes/user/DAO.php(125): Illuminate\\Database\\Query\\Builder->get()\n#7 /var/www/html/lib/pkp/classes/user/Collector.php(97): PKP\\user\\DAO->getMany()\n#8 /var/www/html/lib/pkp/classes/controllers/grid/users/reviewer/PKPReviewerGridHandler.php(480): PKP\\user\\Collector->getMany()\n#9 [internal function]: PKP\\controllers\\grid\\users\\reviewer\\PKPReviewerGridHandler->getUsersNotAssignedAsReviewers()\n#10 /var/www/html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()\n#11 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.php(291): PKP\\core\\PKPRouter->_authorizeInitializeAndCallRequest()\n#12 /var/www/html/lib/pkp/classes/core/Dispatcher.php(165): PKP\\core\\PKPComponentRouter->route()\n#13 /var/www/html/lib/pkp/classes/core/PKPApplication.php(388): PKP\\core\\Dispatcher->dispatch()\n#14 /var/www/html/index.php(21): PKP\\core\\PKPApplication->execute()\n#15 {main}\n thrown in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760, referer: https://ojs.abcdefghijklmnopqrstuv.stream/index.php/de/workflow/index/8/3
Please let me know how I can provide further info to debug. I hid the subdomain which is incidently the same as the name I was searching for.
This is a new 3.4.0-5 installation. Trying to play around with it and got this error in error.log when searching for a reviewer
[Mon Mar 04 21:21:24.374135 2024] [php:error] [pid 19] [client 192.168.176.1:36534] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.user_id' in 'where clause' in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): PDO->prepare()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()\n#3 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()\n#4 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()\n#5 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()\n#6 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#7 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()\n#8 /var/www/html/lib/pkp/classes/user/DAO.php(125): Illuminate\\Database\\Query\\Builder->get()\n#9 /var/www/html/lib/pkp/classes/user/Collector.php(97): PKP\\user\\DAO->getMany()\n#10 /var/www/html/lib/pkp/classes/controllers/grid/users/reviewer/PKPReviewerGridHandler.php(480): PKP\\user\\Collector->getMany()\n#11 [internal function]: PKP\\controllers\\grid\\users\\reviewer\\PKPReviewerGridHandler->getUsersNotAssignedAsReviewers()\n#12 /var/www/html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()\n#13 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.php(291): PKP\\core\\PKPRouter->_authorizeInitializeAndCallRequest()\n#14 /var/www/html/lib/pkp/classes/core/Dispatcher.php(165): PKP\\core\\PKPComponentRouter->route()\n#15 /var/www/html/lib/pkp/classes/core/PKPApplication.php(388): PKP\\core\\Dispatcher->dispatch()\n#16 /var/www/html/index.php(21): PKP\\core\\PKPApplication->execute()\n#17 {main}\n\nNext Illuminate\\Database\\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.user_id' in 'where clause' (SQL: selectu.* fromusersasuwhereu.disabled= 0 and exists (select * fromuser_user_groupsasuuginner joinuser_groupsasugonuug.user_group_id=ug.user_group_idleft join (selectuug.user_idfromuser_user_groupsasuuginner joinuser_groupsasugonuug.user_group_id=ug.user_group_idwhereuug.user_id=u.user_idandug.context_idin (1) andug.role_idin (4096)) asagronuug.user_id=agr.user_idwhereuug.user_id=u.user_idandug.context_idin (1) andagr.user_idis null) and (LOWER(u.username) LIKE LOWER(%abcdefghijklmnopqrstuv@g%) or LOWER(u.email) LIKE LOWER(%mpulis@g%) or exists (select * fromuser_settingsasuswhereus.user_id=u.user_idandus.setting_namein (givenName, familyName, preferredPublicName, affiliation, biography, orcid) and LOWER(us.setting_value) LIKE LOWER(%abcdefghijklmnopqrstuv@g%)) or exists (select * fromuser_interestsasuiinner joincontrolled_vocab_entry_settingsascvesonui.controlled_vocab_entry_id=cves.controlled_vocab_entry_idwhereui.user_id=u.user_idand LOWER(cves.setting_value) LIKE LOWER(%mpulis@g%))) order byu.user_idasc) in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760\nStack trace:\n#0 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()\n#1 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()\n#2 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()\n#3 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()\n#4 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()\n#5 /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()\n#6 /var/www/html/lib/pkp/classes/user/DAO.php(125): Illuminate\\Database\\Query\\Builder->get()\n#7 /var/www/html/lib/pkp/classes/user/Collector.php(97): PKP\\user\\DAO->getMany()\n#8 /var/www/html/lib/pkp/classes/controllers/grid/users/reviewer/PKPReviewerGridHandler.php(480): PKP\\user\\Collector->getMany()\n#9 [internal function]: PKP\\controllers\\grid\\users\\reviewer\\PKPReviewerGridHandler->getUsersNotAssignedAsReviewers()\n#10 /var/www/html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()\n#11 /var/www/html/lib/pkp/classes/core/PKPComponentRouter.php(291): PKP\\core\\PKPRouter->_authorizeInitializeAndCallRequest()\n#12 /var/www/html/lib/pkp/classes/core/Dispatcher.php(165): PKP\\core\\PKPComponentRouter->route()\n#13 /var/www/html/lib/pkp/classes/core/PKPApplication.php(388): PKP\\core\\Dispatcher->dispatch()\n#14 /var/www/html/index.php(21): PKP\\core\\PKPApplication->execute()\n#15 {main}\n thrown in /var/www/html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760, referer: https://ojs.abcdefghijklmnopqrstuv.stream/index.php/de/workflow/index/8/3Please let me know how I can provide further info to debug. I hid the subdomain which is incidently the same as the name I was searching for.