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

Zend_Db_Statement_Exception when loading customers

XMLWordPrintable

    • High
    • Fixed a bug when no customers were set to a language resource.

      problem

      Following exception

           message: Zend_Db_Statement_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))' at line 1, query w
as: SELECT distinct(customerId) AS `customers` FROM `LEK_languageresources_customerassoc` WHERE (languageResourceId IN())

      solution 

      is caused when customers are loaded for usage logging of a language resource but no customers assigned to the ressource. 

      Basically a usage problem by the user, but above exception should be prevented.
       
       
       

       

            tlauria Thomas Lauria
            tlauria Thomas Lauria
            Axel Becher
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: