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

Filtering source language column in task overview throws an error

    XMLWordPrintable

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

      {main}

      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

      Attachments

        Activity

          People

            aleksandar Aleksandar Mitrev
            tlauria Thomas Lauria
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: