Error in query

[amadesa]

Hello,

I've recently upgrade to 1.8.1 from a repository on Ubuntu 10.04.01 LTS.

It seems that all my "hand made" triggers now don't work when I try to edit them.

And I get the following error when I click to edit the Expression of the Trigger:

* Error in query [SELECT DISTINCT applicationid,name FROM applications WHERE hostid= ORDER BY name] [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 'ORDER BY name' at line 1]
* mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/include/db.inc.php:546]
* mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/include/db.inc.php:548]


Any help in resolving this would be greatly appreciated.

[amadesa]

Anyone ?

[amadesa]

I upgraded the frontend to 1.8.4 and now the trigger expression is simply un-clickable .. where in 1.8.1 it was clickable and then gave me the error...

Any help would be greatly appreciated.

[amadesa]

I also noticed that if I click on the Expression (Toggle input method) link, it will show a red X in the Error column and if I hover it with my mouse, it says: "Unknown host item, no such item in selected host"

[amadesa]

So it just seems I cannot edit nor test any web scenarios.

How can I fix this?