-
Incident report
-
Resolution: Fixed
-
Minor
-
None
-
1.4.2
-
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