Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-7879

SQL syntax error when applying templates that contain applications with names containing any ot the letters "åäö" to a host

    XMLWordPrintable

    Details

      Description

      After upgrade to version 2.2.1 from 2.0 I get the following error whenever I try to link a template to a host (where Application name is the name of the application and value is the items contained in that application:

      "Error in query [INSERT INTO applications (name,hostid,applicationid) VALUES ('[Application name]','[value]','[value]' ,] [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 1]SQL statement execution has failed "INSERT INTO applications (name,hostid,applicationid) VALUES ('[Application name]','[value]','[value]' ,"."

      The error occurs on all templates that contains an application with a name containing any of the following letters; å,ä,ö (swedish alphabet). The error disappears and I can successfully link a template to a host if I rename the application that contains any of the above mentioned characters. It will only complain when these characters are in the application. using the characters in items, triggers or graphs does not cause any errors.

      This is a new problem since upgrading to 2.2.1.

        Attachments

          Activity

            People

            Assignee:
            iivs Ivo Kurzemnieks
            Reporter:
            emil.odepark Emil Odepark
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: