We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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.* from usersasuwhereu.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_id 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
[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.
The text was updated successfully, but these errors were encountered:
No branches or pull requests
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.
The text was updated successfully, but these errors were encountered: