PHP Error [E9999 core] Zend_Db_Statement_Exception: SQLSTATE[21000]: Cardinality violation

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • None
    • Affects Version/s: None
    • Component/s: Editor general

      problem from sys log

      [E9999 core] Zend_Db_Statement_Exception: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row, query was:  SELECT Zf_users.`id`, Zf_users.`userGuid`, Zf_users.`firstName`, Zf_users.`surName`, Zf_users.`gender`, ...

      Log ID: 1072785
      Created: 2026-02-25 13:45:09
      Level: 2
      Event Code: E9999
      Domain: core
      Message: Zend_Db_Statement_Exception: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row, query was: SELECT Zf_users.`id`, Zf_users.`userGuid`, Zf_users.`firstName`, Zf_users.`surName`, Zf_users.`gender`, Zf_users.`login`, Zf_users.`email`, Zf_users.`roles`, Zf_users.`editable`, Zf_users.`locale`, Zf_users.`customers`,filter.taskGuid from Zf_users, (SELECT `LEK_task`.* FROM `LEK_task`
      LEFT JOIN `LEK_taskUserAssoc` AS `LEK_taskUserAssoc_1` ON LEK_taskUserAssoc_1.taskGuid = LEK_task.taskG
      App Version: 7.34.5
      File: /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php (235)

      Trace:
      #0 /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
      #1 /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
      #2 /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(267): Zend_Db_Adapter_Abstract->query()
      #3 /var/www/instances-local/instance-1139/application/modules/editor/Models/Task.php(451): Zend_Db_Adapter_Pdo_Abstract->query()
      #4 /var/www/instances-local/instance-1139/application/modules/editor/Controllers/TaskController.php(339): editor_Models_Task->loadUserList()
      #5 /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(522): editor_TaskController->userlistAction()
      #6 /var/www/instances-local/instance-1139/library/ZfExtended/Controllers/AAARestController.php(352): Zend_Controller_Action->dispatch()
      #7 /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch()
      #8 /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
      #9 /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php(106): Zend_Controller_Front->dispatch()
      #10 /var/www/instances-local/instance-1139/vendor/shardj/zf1-future/library/Zend/Application.php(400): Zend_Application_Bootstrap_Bootstrap->run()
      #11 /var/www/instances-local/instance-1139/library/ZfExtended/Application.php(75): Zend_Application->run()
      #12 /var/www/instances-local/instance-1139/library/ZfExtended/BaseIndex.php(178): ZfExtended_Application->run()
      #13 /var/www/instances-local/instance-1139/public/index.php(35): ZfExtended_BaseIndex->startApplication()
      #14

      {main}

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

              Created:
              Updated: