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

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Minor
    • None
    • Affects Version/s: 1.4.2
    • Component/s: 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

            Assignee:
            Alexei Vladishev
            Reporter:
            Clayton Kramer
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: