Error displaying images in 1.1beta5

[herr_bpl]

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

[Alexei]

Version of MySQL?

[herr_bpl]

Hello.

mysql> status
--------------
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

Siim

[herr_bpl]

I understand, problem is with union clausel in query? Are version 1.1beta4 frontent graph drawing components compatible with 1.1beta5 so i could for time being replace this component with pervious version ?

Any helpful feedback appreciated,
Thank you,

Siim

[Alexei]

Yes, replace it with previous version. The SQL will work for MySQL v4.0.0 and higher.