Graphs and SQL Errors

[Palmertree]

Has anyone seen this before with Zabbix 1.1.4 when configuring graphs when selecting "Group" = all and "Host"=all:

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.hostid' at line 1]

The screen fills up with this error.

[Palmertree]

Can someone else try this please to see if they get the same error. I am wondering if it something on my end.

[dantheman]

I just tried this, on 1.1.4 clicked on Configuration, graphs and then chose group = All and host=all and did not see this error... do you have any graphs configured? I have about 10 setup.

[Palmertree]

i had about 80 graphs. Thanks for trying. I ended up Truncating the SQL table GRAPHS and it works now.