Small bug.

[cybaspace]

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!

[mbjoerling]

Hi

What version of MySQL do you use?

[Alexei]

Try to switch to 1.1.1. I believe the issue is already fixed.

[themons]

no problème on the 1.1.1