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

Host ID sql script has 'while' instead of 'where' clause in graphs.php

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • None
    • 1.4.2
    • Frontend (F)
    • None

      After enabling distributed monitoring I found this on the graphs.php page in configuration mode.

      • Error in query [select distinct g.* from graphs g left join graphs_items gi on g.graphid=gi.graphid left join items i on gi.itemid=i.itemid while (g.graphid div 100000000000000) in (1) and ( i.hostid not in (-1) OR i.hostid is NULL ) order by g.name, g.graphid] [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 'while (g.graphid div 100000000000000) in (1) and ( i.hostid not in (-1) OR i.' at line 1]
      • mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:411]

      Checking the graphs.php page I found 'while' in the sql string instead of 'where'.

      Line 348 Char 35

            alexei Alexei Vladishev
            claytronic Clayton Kramer
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: