problem

On demo aleks instance I tried to authenticate via our sso keycloak server. 

The result was the following PHP error with trace below. 

Problem is, that at the point of time when the assertCustomersMayBeAssociatedWithUser call with underlying CoordinatorGroupUserRepository->getByUser is called - the user is not yet in DB! 

solution

Prevent that error, find out if we have a logical problem in combination of SSO and Coordinator Groups!

trace

Log ID: 100948
Created: 2026-10-01 18:50:41
Level: 2
Event Code: E9999
Domain: core
Message: Zend_Db_Statement_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?)' at line 2, query was: SELECT `group`.*, `groupToUser`.`guid` FROM `LEK_coordinator_group` AS `group`
INNER JOIN `LEK_coordinator_group_user` AS `groupToUser` ON `group`.id = groupToUser.groupId WHERE (groupToUser.userId = ?)
App Version: 7.45.1
File: /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php (235)

Trace:
#0 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(304): Zend_Db_Statement_Pdo->_execute()
#1 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#2 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(267): Zend_Db_Adapter_Abstract->query()
#3 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(759): Zend_Db_Adapter_Pdo_Abstract->query()
#4 /var/www/instances-local/instance-1513/application/modules/editor/src/Repository/CoordinatorGroupUserRepository.php(105): Zend_Db_Adapter_Abstract->fetchRow()
#5 /var/www/instances-local/instance-1513/application/modules/editor/src/Repository/CoordinatorGroupUserRepository.php(82): MittagQI\Translate5\Repository\CoordinatorGroupUserRepository->getByUser()
#6 /var/www/instances-local/instance-1513/application/modules/editor/src/User/Validation/UserCustomerAssociationValidator.php(77): MittagQI\Translate5\Repository\CoordinatorGroupUserRepository->findByUser()
#7 /var/www/instances-local/instance-1513/application/modules/editor/src/User/Operations/UserAssignCustomersOperation.php(79): MittagQI\Translate5\User\Validation\UserCustomerAssociationValidator->assertCustomersMayBeAssociatedWithUser()
#8 /var/www/instances-local/instance-1513/application/modules/editor/src/User/Operations/UpdateUserCustomersAssignmentsOperation.php(74): MittagQI\Translate5\User\Operations\UserAssignCustomersOperation->assignCustomers()
#9 /var/www/instances-local/instance-1513/application/modules/editor/src/Authentication/OpenId/Client.php(198): MittagQI\Translate5\User\Operations\UpdateUserCustomersAssignmentsOperation->updateCustomers()
#10 /var/www/instances-local/instance-1513/application/modules/default/Controllers/LoginController.php(279): MittagQI\Translate5\Authentication\OpenId\Client->createOrMergeUser()
#11 /var/www/instances-local/instance-1513/application/modules/default/Controllers/LoginController.php(86): LoginController->handleOpenIdRequest()
#12 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(528): LoginController->indexAction()
#13 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch()
#14 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#15 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
#16 /var/www/instances-local/instance-1513/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run()
#17 /var/www/instances-local/instance-1513/library/ZfExtended/Application.php(75): Zend_Application->run()
#18 /var/www/instances-local/instance-1513/library/ZfExtended/BaseIndex.php(178): ZfExtended_Application->run()
#19 /var/www/instances-local/instance-1513/public/index.php(35): ZfExtended_BaseIndex->startApplication()
#20