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

Login: Syntax error or access violation (depending on role)

    XMLWordPrintable

Details

    • High

    Description

      After login as translator 1, error is shown in frontend and in error-log (login as manager is ok):

      ERROR Zend_Db_Statement_Exception: E9999 - 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 'filter.pmGuid = "'{c99ae747-0afb-446a-827a-6b3b32cfb819}'" OR LEK_taskUserAss...' at line 2, query was: SELECT Zf_users.,filter.taskGuid from Zf_users, (SELECT `LEK_task`. FROM `LEK_task`
      LEFT JOIN `LEK_taskUserAssoc` AS `LEK_taskUserAssoc_1` ON LEK_taskUserAssoc_1.taskGuid = LEK_task.taskGuid WHERE (LEK_taskUserAssoc_1.userGuid = '{c99ae747-0afb-446a-827a-6b3b32cfb819}' OR LEK_task.pmGuid = '{c99ae747-0afb-446a-827a-6b3b32cfb819}') ORDER BY `LEK_task`.`orderdate` desc) as filter INNER JOIN LEK_taskUserAssoc ON LEK_taskUserAssoc.taskGuid=filter.taskGuid INNER JOIN LEK_customer ON LEK_customer.id=filter.customerId AND LEK_customer.anonymizeUsers=0OR filter.pmGuid = "'{c99ae747-0afb-446a-827a-6b3b32cfb819}'" OR LEK_taskUserAssoc.userGuid = "'{c99ae747-0afb-446a-827a-6b3b32cfb819}'"WHERE Zf_users.userGuid = LEK_taskUserAssoc.userGuid GROUP BY Zf_users.id ORDER BY Zf_users.surName; (...)

      Previous Exception:

      ERROR PDOException: E9999 - 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 'filter.pmGuid = "'{c99ae747-0afb-446a-827a-6b3b32cfb819}'" OR LEK_taskUserAss...' at line 2 (...)

      Attachments

        Activity

          People

            aleksandar Aleksandar Mitrev
            Ines-Paul Ines-Paul Baumann (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: