New error

[fmtaylor2]

This is showing up on the dashboard starting with the revision 9509.

* Undefined index: clock[/var/www/html/zabbix/include/triggers.inc.php:1399]
* Error in query [select value from history where itemid=56389 and clock<= order by itemid,clock desc LIMIT 1 OFFSET 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 'order by itemid,clock desc LIMIT 1 OFFSET 0' at line 1]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:546]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:548]
* Undefined index: clock[/var/www/html/zabbix/include/triggers.inc.php:1399]
* Error in query [select value from history where itemid=56389 and clock<= order by itemid,clock desc LIMIT 1 OFFSET 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 'order by itemid,clock desc LIMIT 1 OFFSET 0' at line 1]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:546]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:548]

[hulting74]

Same issue

* Undefined index: clock[/var/www/include/triggers.inc.php:1399]
* Error in query [select value from history_uint where itemid=36798 and clock<= order by itemid,clock desc LIMIT 1 OFFSET 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 'order by itemid,clock desc LIMIT 1 OFFSET 0' at line 1]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:546]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:548]

[hulting74]

Solution

Hi

Solution was for me

Remove ITEM.VALUE from all triggers

Ex Low free disk space on {HOSTNAME} volume D: in % (5%) now {ITEM.VALUE}%

where i removed the ITEM.VALUE from the trigger...

/S