-
Bug
-
Resolution: Fixed
-
None
-
Critical
-
Fix general DB error when using percentage filters (like finished column) as client PM.
-
Emptyshow more show less
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