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

Illegal query at sending of the configuration data on a proxy-server, if a configuration empty

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 1.9.1 (alpha)
    • 1.9.1 (alpha)
    • Proxy (P), Server (S)
    • None
    • releng_8, mysql 5.5, zabbix revision 15285

      empty "where" section in query:

      70466:20101106:150924.400 [Z3005] Query failed: [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 'order by t.hostid' at line 1 [select t.hostid,t.host,t.dns,t.useip,t.ip,t.port,t.useipmi,t.ipmi_port,t.ipmi_authtype,t.ipmi_privilege,t.ipmi_username,t.ipmi_password,t.ipmi_ip from hosts t where order by t.hostid]
      70466:20101106:150924.400 [Z3005] Query failed: [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 'order by t.hostmacroid' at line 1 [select t.hostmacroid,t.hostid,t.macro,t.value from hostmacro t where order by t.hostmacroid]
      70466:20101106:150924.401 Sending configuration data to proxy 'msk-be-vpn201'. Datalen 1103

            Unassigned Unassigned
            jimson Vladimir Kravchenko
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: