PHP error when user has no customers assigned

XMLWordPrintable

    • High
    • None
    • PHP error fixed
    • None

      Log ID: 609257
      Created: 2026-04-16 16:23:17
      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 DISTINCT `lr`.`id` FROM `LEK_languageresources` AS `lr`
      INNER JOIN `LEK_languageresources_customerassoc` AS `lr2c` ON `lr2c`.`languageResourceId` = `lr`.`id` WHERE (`lr`.`resourceType` = 'termcollection') AND (customerId IN ())
      App Version: 7.36.0
      File: /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php (235)

      Trace:
      #0 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
      #1 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
      #2 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(267): Zend_Db_Adapter_Abstract->query()
      #3 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Db/Table/Abstract.php(1590): Zend_Db_Adapter_Pdo_Abstract->query()
      #4 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Db/Table/Abstract.php(1405): Zend_Db_Table_Abstract->_fetch()
      #5 /var/www/instances-local/instance-1130/application/modules/editor/Models/TermCollection/TermCollection.php(558): Zend_Db_Table_Abstract->fetchAll()
      #6 /var/www/instances-local/instance-1130/application/modules/editor/Plugins/TermPortal/Init.php(202): editor_Models_TermCollection_TermCollection->getAccessibleCollectionIds()
      #7 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/EventManager/EventManager.php(469): editor_Plugins_TermPortal_Init->setupProposableCollections()
      #8 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/EventManager/EventManager.php(208): Zend_EventManager_EventManager->triggerListeners()
      #9 /var/www/instances-local/instance-1130/library/ZfExtended/EventManager.php(74): Zend_EventManager_EventManager->trigger()
      #10 /var/www/instances-local/instance-1130/library/ZfExtended/Controllers/AAARestController.php(260): ZfExtended_EventManager->trigger()
      #11 /var/www/instances-local/instance-1130/library/ZfExtended/Controllers/AAARestController.php(224): ZfExtended_RestController->afterActionEvent()
      #12 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(527): ZfExtended_RestController->postDispatch()
      #13 /var/www/instances-local/instance-1130/library/ZfExtended/Controllers/AAARestController.php(354): Zend_Controller_Action->dispatch()
      #14 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch()
      #15 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
      #16 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
      #17 /var/www/instances-local/instance-1130/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run()
      #18 /var/www/instances-local/instance-1130/library/ZfExtended/Application.php(75): Zend_Application->run()
      #19 /var/www/instances-local/instance-1130/library/ZfExtended/BaseIndex.php(178): ZfExtended_Application->run()
      #20 /var/www/instances-local/instance-1130/public/index.php(35): ZfExtended_BaseIndex->startApplication()
      #21

      {main}

            Assignee:
            Sanya Mikhliaiev
            Reporter:
            Thomas Lauria
            None
            None
            Thomas Lauria
            Stephan Bergmann, Sylvia Schumacher
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:
              None
              None