cybaspace
07-08-2006, 15:57
Hi,
I am using the stable v1.1 version of zabbix and I am testdriving it a bit.
When I go to the comments of an active trigger and then monitoring I get the following error:
-------------------
Error in query [select * from triggers where triggerid=] [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 '' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/zabbix/include/db.inc.php on line 174
Error in query [select distinct t.description,h.host from triggers t,functions f,items i,hosts h where t.triggerid= and f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h.hostid] [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 f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/zabbix/include/db.inc.php on line 174
Error in query [select description from triggers where triggerid=] [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 '' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/zabbix/include/db.inc.php on line 174
No trigger with triggerid=[]
----------------------
Are there more people experiencing this problem or is it already patched?
Cheers!
I am using the stable v1.1 version of zabbix and I am testdriving it a bit.
When I go to the comments of an active trigger and then monitoring I get the following error:
-------------------
Error in query [select * from triggers where triggerid=] [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 '' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/zabbix/include/db.inc.php on line 174
Error in query [select distinct t.description,h.host from triggers t,functions f,items i,hosts h where t.triggerid= and f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h.hostid] [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 f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/zabbix/include/db.inc.php on line 174
Error in query [select description from triggers where triggerid=] [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 '' at line 1]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/zabbix/include/db.inc.php on line 174
No trigger with triggerid=[]
----------------------
Are there more people experiencing this problem or is it already patched?
Cheers!