query failed: [1064]

[mikedavis]

Hi,

When I try to update to zabbix 1.8.6, 1.8.7, or even 1.8.8rc1, i get an error in the logs stating the following:

 28277:20110912:123829.029 [Z3005] query failed: [1064] 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 'items set lastclock=1315856307,prevorgvalue='55263561925.000000',prevvalue=lastv' at line 1 [update items set lastclock=1315856305,prevorgvalue='1703063015468.000000',prevvalue=lastvalue,lastvalue='66.739625' where itemid=10610600000018440update items set lastclock=1315856307,prevorgvalue='55263561925.000000',prevvalue=lastvalue,lastvalue='122.002881' where itemid=10610600000018442update items set lastclock=1315856308,prevorgvalue='90071962590.000000',prevvalue=lastvalue,lastvalue='155.145844' where itemid=10610600000018443update items set lastclock=1315856305,prevorgvalue='55263560764.000000',prevvalue=lastvalue,lastvalue='259.397114' where itemid=10610600000018445update items set lastclock=1315856307,prevvalue=lastvalue,lastvalue='0.010000' where itemid=10610600000018467update items set lastclock=1315856308,prevvalue=lastvalue,lastvalue='0.000000' where itemid=10610600000018468update items set lastclock=1315856304,prevvalue=lastvalue,lastvalue='0.041583' where itemid=10610600000018474update items set lastclock=1315856304,prevvalue=lastvalue,lastvalue='76.946350' where itemid=10610600000018514update items set lastclock=1315856305,prevvalue=lastvalue,lastvalue='23.053650' where itemid=10610600000018515update items set lastclock=1315856307,prevvalue=lastvalue,lastvalue='6076215296' where itemid=10610600000018517update items set lastclock=1315856308,prevvalue=lastvalue,lastvalue='20280631296' where itemid=10610600000018518]
 28279:20110912:123834.030 [Z3005] query failed: [1064] 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 'items set lastclock=1315856312,prevorgvalue='55263571802.000000',prevvalue=lastv' at line 1 [update items set lastclock=1315856310,prevorgvalue='1703063015600.000000',prevvalue=lastvalue,lastvalue='66.738624' where itemid=10610600000018440update items set lastclock=1315856312,prevorgvalue='55263571802.000000',prevvalue=lastvalue,lastvalue='122.046864' where itemid=10610600000018442update items set lastclock=1315856313,prevorgvalue='90071964402.000000',prevvalue=lastvalue,lastvalue='155.150389' where itemid=10610600000018443update items set lastclock=1315856310,prevorgvalue='55263568905.000000',prevvalue=lastvalue,lastvalue='259.427135' where itemid=10610600000018445update items set lastclock=1315856311,prevvalue=lastvalue,lastvalue='137' where itemid=10610600000018461update items set lastclock=1315856313,prevvalue=lastvalue,lastvalue='0.000000' where itemid=10610600000018468update items set lastclock=1315856309,prevvalue=lastvalue,lastvalue='0.040000' where itemid=10610600000018469update items set lastclock=1315856310,prevvalue=lastvalue,lastvalue='99.883498' where itemid=10610600000018470update items set lastclock=1315856311,prevvalue=lastvalue,lastvalue='0.016643' where itemid=10610600000018471update items set lastclock=1315856312,prevvalue=lastvalue,lastvalue='0.041604' where itemid=10610600000018472update items set lastclock=1315856313,prevvalue=lastvalue,lastvalue='0.016635' where itemid=10610600000018473update items set lastclock=1315856309,prevvalue=lastvalue,lastvalue='1625045' where itemid=10610600000018489update items set lastclock=1315856310,prevvalue=lastvalue,lastvalue='94.198081' where itemid=10610600000018490update items set lastclock=1315856312,prevvalue=lastvalue,lastvalue='1625045' where itemid=10610600000018492update items set lastclock=1315856313,prevvalue=lastvalue,lastvalue='94.198081' where itemid=10610600000018493update items set lastclock=1315856309,prevvalue=lastvalue,lastvalue='76.946334' where itemid=10610600000018519update items set lastclock=1315856310,prevvalue=lastvalue,lastvalue='23.053666' where itemid=10610600000018520update items set lastclock=1315856312,prevvalue=lastvalue,lastvalue='6076219392' where itemid=10610600000018522update items set lastclock=1315856313,prevvalue=lastvalue,lastvalue='20280627200' where itemid=10610600000018523]

Looks like it is missing a colon or not getting a ";\n". Basically, there is no "Latest Data" for the hosts.

This is on ubuntu 10.04.3 LTS with mysql 5.1.58. I have same issue on Debian Lenny with mysql 5.0.51a.

If i rollback and just do a make install on zabbix 1.8.5, the issue resolves itself. Zabbix 1.8.5 runs fine(with the exclusion of bugs fixed in later versions)

If I can update source code and redo a configure make install, please let me know. Thanks,