Details
-
Bug
-
Resolution: Fixed
-
None
-
None
-
None
Description
Problem: using the source language filter in the taskoverview throws an error, see below. MatchResource must be enabled. Seems to come from there.
ZfExtended_Log on www.translate5.net: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 2, query was: SELECT `LEK_matchresource_tmmt`.*, `LEK_matchresource_taskassoc`.`taskGuid` FROM `LEK_matchresource_tmmt`
INNER JOIN `LEK_matchresource_taskassoc` ON LEK_matchresource_taskassoc.`tmmtId` = LEK_matchresource_tmmt.`id` WHERE (LEK_matchresource_taskassoc.`taskGuid` in ())
current user: manager
#0 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array)
#3 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Db/Table/Abstract.php(1575): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select))
#4 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Db/Table/Abstract.php(1390): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
#5 /webs/www.translate5.net/application/modules/editor/Plugins/MatchResource/Models/TmMt.php(80): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select))
#6 /webs/www.translate5.net/application/modules/editor/Plugins/MatchResource/Init.php(134): editor_Plugins_MatchResource_Models_TmMt->loadByAssociatedTaskGuidList(Array)
#7 [internal function]: editor_Plugins_MatchResource_Init->handleAfterTaskIndexAction(Object(Zend_EventManager_Event))
#8 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/EventManager/EventManager.php(469): call_user_func(Array, Object(Zend_EventManager_Event))
#9 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/EventManager/EventManager.php(208): Zend_EventManager_EventManager->triggerListeners('afterIndexActio...', Object(Zend_EventManager_Event), NULL)
#10 /webs/www.translate5.net/library/ZfExtended/EventManager.php(74): Zend_EventManager_EventManager->trigger('afterIndexActio...', Object(editor_TaskController), Array, NULL)
#11 /webs/www.translate5.net/library/ZfExtended/Controllers/AAARestController.php(145): ZfExtended_EventManager->trigger('afterIndexActio...', Object(editor_TaskController), Array)
#12 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Controller/Action.php(521): ZfExtended_RestController->postDispatch()
#13 /webs/www.translate5.net/library/ZfExtended/Controllers/AAARestController.php(234): Zend_Controller_Action->dispatch('indexAction')
#14 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('indexAction')
#15 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#16 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()
#17 /webs/includes/ZendFramework-1.12.9-minimal/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#18 /webs/www.translate5.net/library/ZfExtended/BaseIndex.php(157): Zend_Application->run()
#19 /webs/www.translate5.net/public/index.php(43): ZfExtended_BaseIndex->startApplication()
#20
Aufgerufene URL inkl. ggf. vorhandener POST-Parameter als get-Parameter:
/editor/task/index/_dc/1474035691401/page/1/start/0/limit/20/filter/[
{"operator":"in","value":["124"],"property":"sourceLang"},
{"operator":"in","value":["150"],"property":"targetLang"},
{"operator":"=","value":true,"property":"referenceFiles"},
{"operator":"lt","value":"02.09.2016","property":"targetDeliveryDate"}]/format/json