herr_bpl
04-01-2006, 16:04
Hi all.
Following error occurs when drawing graphs (http://monitoring/zabbix/chart2.php?graphid=6&period=3600&from=0):
Error in query [select itemid,round(900*((clock+2433)%(3600))/(3600),0) as i,count(*) as count,avg(value) as avg,min(value) as min,max(value) as max,max(clock) as clock from history where itemid in ( 17643,17644,17647) and clock>=1136377167 and clock<=1136380767 group by itemid,round(900*((clock+2433)%(3600))/(3600),0) union select itemid,round(900*((clock+2433)%(3600))/(3600),0) as i,count(*) as count,avg(value) as avg,min(value) as min,max(value) as max,max(clock) as clock from history_uint where itemid in ( 17643,17644,17647) and clock>=1136377167 and clock<=1136380767 group by itemid,round(900*((clock+2433)%(3600))/(3600),0)] [You have an error in your SQL syntax near 'union select itemid,round(900*((clock+2433)%(3600))/(3600),0) as i,count(*) as c' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/zabbix/include/db.inc.php on line 109
Following error occurs when drawing graphs (http://monitoring/zabbix/chart2.php?graphid=6&period=3600&from=0):
Error in query [select itemid,round(900*((clock+2433)%(3600))/(3600),0) as i,count(*) as count,avg(value) as avg,min(value) as min,max(value) as max,max(clock) as clock from history where itemid in ( 17643,17644,17647) and clock>=1136377167 and clock<=1136380767 group by itemid,round(900*((clock+2433)%(3600))/(3600),0) union select itemid,round(900*((clock+2433)%(3600))/(3600),0) as i,count(*) as count,avg(value) as avg,min(value) as min,max(value) as max,max(clock) as clock from history_uint where itemid in ( 17643,17644,17647) and clock>=1136377167 and clock<=1136380767 group by itemid,round(900*((clock+2433)%(3600))/(3600),0)] [You have an error in your SQL syntax near 'union select itemid,round(900*((clock+2433)%(3600))/(3600),0) as i,count(*) as c' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/zabbix/include/db.inc.php on line 109