Error in Configurating -> IT Services
I have FreeBSD 6.1, Mysql 5.0 and zabbix 1.1.
when i change server "add server datailes" in configurating -> IT services,
and push button "add server"
i get this error
Error in query [select count(*) as cnt from services_links where servicedownid= and soft=0] [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 'and soft=0' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/www/apache22/data/zabbix/html/include/db.inc.php on line 174
Error in query [select count(*) as cnt from services_links where servicedownid= and soft=0] [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 'and soft=0' at line 1]
SQL error: 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 'on,0,off,99)' at line 1
Query: insert into services (name,status,triggerid,algorithm,showsla,goodsla,s ortorder) values ('Version of zabbix_agent(d) was changed on {HOSTNAME}',0,12255,on,0,off,99)
what wrong ???
when i change server "add server datailes" in configurating -> IT services,
and push button "add server"
i get this error
Error in query [select count(*) as cnt from services_links where servicedownid= and soft=0] [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 'and soft=0' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/www/apache22/data/zabbix/html/include/db.inc.php on line 174
Error in query [select count(*) as cnt from services_links where servicedownid= and soft=0] [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 'and soft=0' at line 1]
SQL error: 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 'on,0,off,99)' at line 1
Query: insert into services (name,status,triggerid,algorithm,showsla,goodsla,s ortorder) values ('Version of zabbix_agent(d) was changed on {HOSTNAME}',0,12255,on,0,off,99)
what wrong ???