Fatal error: Uncaught PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "FROM"
LINE 1: ...=19) ASC, CONCAT(COALESCE((SELECT `setting_value` FROM `user...
^ in /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:412
Stack trace:
#0 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(412): PDOStatement->execute()
#1 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run()
#4 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\Database\Connection->select()
#5 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\Database\Query\Builder->runSelect()
#6 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /var/www/html/ojs/lib/pkp/classes/userGroup/Repository.php(604): Illuminate\Database\Query\Builder->get()
#9 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(427): PKP\userGroup\Repository->PKP\userGroup\{closure}()
#10 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(453): Illuminate\Cache\Repository->remember()
#11 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Cache\CacheManager->__call()
#12 /var/www/html/ojs/lib/pkp/classes/userGroup/Repository.php(581): Illuminate\Support\Facades\Facade::__callStatic()
#13 /var/www/html/ojs/lib/pkp/pages/about/AboutContextHandler.php(99): PKP\userGroup\Repository->getMastheadUserIdsByRoleIds()
#14 [internal function]: PKP\pages\about\AboutContextHandler->editorialMasthead()
#15 /var/www/html/ojs/lib/pkp/classes/core/PKPRouter.php(327): call_user_func()
#16 /var/www/html/ojs/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest()
#17 /var/www/html/ojs/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route()
#18 /var/www/html/ojs/lib/pkp/classes/core/PKPApplication.php(429): PKP\core\Dispatcher->dispatch()
#19 /var/www/html/ojs/index.php(21): PKP\core\PKPApplication->execute()
#20 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "FROM"
LINE 1: ...=19) ASC, CONCAT(COALESCE((SELECT `setting_value` FROM `user...
^ (Connection: pgsql, SQL: select "u".*, "uugob"."user_group_id" from "users" as "u" left join "user_user_groups" as "uugob" on "uugob"."user_id" = "u"."user_id" where "u"."disabled" = 0 and exists (select * from "user_user_groups" as "uug" inner join "user_groups" as "ug" on "uug"."user_group_id" = "ug"."user_group_id" where "uug"."user_id" = "u"."user_id" and "uug"."user_group_id" in (3, 5, 19) and COALESCE(ug.context_id, 0) in (1) and ("uug"."date_start" <= 2026-05-10 11:35:49 or "uug"."date_start" is null) and ("uug"."date_end" > 2026-05-10 11:35:49 or "uug"."date_end" is null) and "ug"."masthead" = 1 and "uug"."masthead" = 1) order by (uugob.user_group_id=3, uugob.user_group_id=5, uugob.user_group_id=19) ASC, CONCAT(COALESCE((SELECT `setting_value` FROM `user_settings` WHERE `user_id` = `u`.`user_id` AND `setting_name` = familyName AND `locale` = en LIMIT 1), (SELECT `setting_value` FROM `user_settings` WHERE `user_id` = `u`.`user_id` AND `setting_name` = familyName AND `locale` = it LIMIT 1), ''), COALESCE((SELECT `setting_value` FROM `user_settings` WHERE `user_id` = `u`.`user_id` AND `setting_name` = givenName AND `locale` = en LIMIT 1), (SELECT `setting_value` FROM `user_settings` WHERE `user_id` = `u`.`user_id` AND `setting_name` = givenName AND `locale` = it LIMIT 1), '')) ASC) in /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
Stack trace:
#0 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\Database\Connection->run()
#2 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3106): Illuminate\Database\Connection->select()
#3 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3091): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3676): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3090): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/html/ojs/lib/pkp/classes/userGroup/Repository.php(604): Illuminate\Database\Query\Builder->get()
#7 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(427): PKP\userGroup\Repository->PKP\userGroup\{closure}()
#8 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(453): Illuminate\Cache\Repository->remember()
#9 /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Cache\CacheManager->__call()
#10 /var/www/html/ojs/lib/pkp/classes/userGroup/Repository.php(581): Illuminate\Support\Facades\Facade::__callStatic()
#11 /var/www/html/ojs/lib/pkp/pages/about/AboutContextHandler.php(99): PKP\userGroup\Repository->getMastheadUserIdsByRoleIds()
#12 [internal function]: PKP\pages\about\AboutContextHandler->editorialMasthead()
#13 /var/www/html/ojs/lib/pkp/classes/core/PKPRouter.php(327): call_user_func()
#14 /var/www/html/ojs/lib/pkp/classes/core/PKPPageRouter.php(249): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest()
#15 /var/www/html/ojs/lib/pkp/classes/core/Dispatcher.php(157): PKP\core\PKPPageRouter->route()
#16 /var/www/html/ojs/lib/pkp/classes/core/PKPApplication.php(429): PKP\core\Dispatcher->dispatch()
#17 /var/www/html/ojs/index.php(21): PKP\core\PKPApplication->execute()
#18 {main}
thrown in /var/www/html/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 825