Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-4682

Fix percentage filter

XMLWordPrintable

    • Critical
    • Fix general DB error when using percentage filters (like finished column) as client PM.

      problem

      Using the finished filter in task grid as client PM will produce a DB error:

       

             ecode: E9999
            domain: core
           message: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'segmentEditableCount' in WHERE is ambiguous
        appVersion: development
       file (line): ✎ /var/www/translate5/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php (228)
              Host: https://t5docker.localdev
               URL: GET https://t5docker.localdev/editor/task?_dc=1748420764838&tab=1&page=1&start=0&limit=20&filter=%5B%7B%22operator%22%3A%22gt%22%2C%22value%22%3A0%2C%22property%22%3A%22segmentFinishCount%22%7D
      %5D
              User: thomastest (Thomas Test) ({ae84bd84-0c19-4e27-ac5d-7197ff1a842d})
             Trace:     ✎ #0 /var/www/translate5/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
          ✎ #1 /var/www/translate5/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
          ✎ #2 /var/www/translate5/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
          ✎ #3 /var/www/translate5/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(267): Zend_Db_Adapter_Abstract->query('SELECT COUNT(di...', Array)
          ✎ #4 /var/www/translate5/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(831): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
          ✎ #5 /var/www/translate5/application/modules/editor/src/Task/DataProvider/TaskViewDataProvider.php(109): Zend_Db_Adapter_Abstract->fetchOne(Object(Zend_Db_Select))
          ✎ #6 /var/www/translate5/application/modules/editor/Controllers/TaskController.php(402): MittagQI\Translate5\Task\DataProvider\TaskViewDataProvider->getTaskList(Object(MittagQI\Translate5\User\Model\User
      ), Object(editor_Models_Filter_TaskSpecific), 0, 20) 

      solution

      Fix percentage filter so that correct table prefix is set

       

            tlauria Thomas Lauria
            tlauria Thomas Lauria
            Volodymyr Kyianenko
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: