SLA seem not to work in the 1.1 release and 1.1.1 versions of Zabbix but it worked back in betas. I get:
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 /var/www/html/zabbix/include/db.inc.php on line 174
[Trigger added]
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 ('Dingo internetas iki TEO',0,12893,on,0,off,99)
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 '29,0)' at line 1
Query: insert into services_links (servicedownid,serviceupid,soft) values (,29,0)
When adding child trigger or servers.
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 /var/www/html/zabbix/include/db.inc.php on line 174
[Trigger added]
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 ('Dingo internetas iki TEO',0,12893,on,0,off,99)
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 '29,0)' at line 1
Query: insert into services_links (servicedownid,serviceupid,soft) values (,29,0)
When adding child trigger or servers.
Comment