I have this message on zabbix interfaz on post reports, specificly on "most busy triggers top 100"
Error in query [select h.host, t.triggerid, t.description, t.priority, count(distinct a.alarmid) as alarmcount from hosts h, triggers t, functions f, items i, alarms a where h.hostid = i.hostid and i.itemid = f.itemid and t.triggerid=f.triggerid and t.triggerid=a.triggerid and a.clock>1182965284-86400 group by h.host,t.triggerid,t.description,t.priority order by 5 desc,1,3] [Table 'zabbix.alarms' doesn't exist]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/share/zabbix/include/db.inc.php on line 104
is possible to create it, or, how I add the missing table?
Error in query [select h.host, t.triggerid, t.description, t.priority, count(distinct a.alarmid) as alarmcount from hosts h, triggers t, functions f, items i, alarms a where h.hostid = i.hostid and i.itemid = f.itemid and t.triggerid=f.triggerid and t.triggerid=a.triggerid and a.clock>1182965284-86400 group by h.host,t.triggerid,t.description,t.priority order by 5 desc,1,3] [Table 'zabbix.alarms' doesn't exist]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/share/zabbix/include/db.inc.php on line 104
is possible to create it, or, how I add the missing table?
Comment