Ad Widget

Collapse

to create a missing table, how?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • migstage
    Junior Member
    • Jun 2007
    • 12

    #1

    to create a missing table, how?

    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?
    Last edited by migstage; 03-07-2007, 15:21. Reason: more explicit
  • InDaClub
    Junior Member
    • Aug 2007
    • 1

    #2
    Problem with zabbi.alarms

    I discover wich is the problem:
    I had it too and i founded why :
    i installed before the zabbix-server 1.1.4 and than i compiled the versione 1.4.2 , and the problem is that if the binary of 1.4.2 is not compiled well , it goes on to call the query to zabbix.alarms that in the news mysql structure doesn't exist anymore .
    You have to be sure that , when u launch zabbix-server , it is really the 1.4.2 and , it will call the new query to alarms , whose name is different from zabbix.alarms , and ... that's it!|!!!

    Comment

    Working...