Zabbix 1.4.4 upgrade to 1.5.1 Mysql errors

[kc5kse]

I've overcome the semaphore and shared memory issues via ipcrm. I have my startup script set to start zabbix_server as user zabbix. Once that is done, I tail the log and get this:

union all select 3,'users',userid,1,concat_ws(',',md5(alias),md5(na me),md5(surname),md5(passwd),md5(url),autologin,au tologout,md5(lang),refresh,type,md5(theme)) from users where 1=1 and userid between 300000000000000 and 399999999999999
union all select 3,'usrgrp',usrgrpid,1,concat_ws(',',md5(name),gui_ access,users_status) from usrgrp where 1=1 and usrgrpid between 300000000000000 and 399999999999999
union all select 3,'users_groups',id,1,concat_ws(',',usrgrpid,useri d) from users_groups where 1=1 and id between 300000000000000 and 399999999999999
union all select 3,'valuemaps',valuemapid,1,concat_ws(',',md5(name) ) from valuemaps where 1=1 and valuemapid between 300000000000000 and 399999999999999
] 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 'triggerid between 300000000000000 and 399999999999999
union all select 3,'sysmap' at line 39 [1064]

I was basically told by Zabbix Support to upgrade to 1.5. Why can't I find a 1.5 download? only 1.5.1!!

Any help would be greatly appreciated!

[bbrendon]

I'm pretty sure no one would recommend you run 1.5.1. Its beta.

You're probably best off with 1.4.5

[pacharest]

You might post more of your log . The error MySQL is giving you (near triggerID) isn't even in the log extract you published.

Pascal

[Alexei]

Version of MySQL?

[BusteR81]

not sure but i hit these errors too

I've overcome the semaphore and shared memory issues via ipcrm. I have my startup script set to start zabbix_server as user zabbix. Once that is done, I tail the log and get this:

union all select 3,'users',userid,1,concat_ws(',',md5(alias),md5(na me),md5(surname),md5(passwd),md5(url),autologin,au tologout,md5(lang),refresh,type,md5(theme)) from users where 1=1 and userid between 300000000000000 and 399999999999999
union all select 3,'usrgrp',usrgrpid,1,concat_ws(',',md5(name),gui_ access,users_status) from usrgrp where 1=1 and usrgrpid between 300000000000000 and 399999999999999
union all select 3,'users_groups',id,1,concat_ws(',',usrgrpid,useri d) from users_groups where 1=1 and id between 300000000000000 and 399999999999999
union all select 3,'valuemaps',valuemapid,1,concat_ws(',',md5(name) ) from valuemaps where 1=1 and valuemapid between 300000000000000 and 399999999999999
] 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 'triggerid between 300000000000000 and 399999999999999
union all select 3,'sysmap' at line 39 [1064]

I was basically told by Zabbix Support to upgrade to 1.5. Why can't I find a 1.5 download? only 1.5.1!!

Any help would be greatly appreciated!

hey i hit this error too. however i view those error via /tmp/zabbix_server.log when i upgrade mysql from 1.4.4 to 1.5.1 (beta). for eg. i lose all the images from from 1.4.4 Maps (i presume somehow the interuption of of 'X' 'Y' coordinates is diff from 1.5.1). the rests of the errors are coming from Configuration -> Actions (coz the new 1.5.1 hostid does not match the 1.4.4 hostid). what i did was to remove those Actions which is assigned to host="PC 1" and recreate the Action with new 1.5.1 hostid.

[Sasha]

Thanks for your report.
Problem fixed in rev. 5663.