I'm testing upgrade process from current Zabbix version to beta. After upgrade I have errors in Zabbix Frontends.
Code:
Error in query [SELECT DISTINCT t.triggerid,t.value,t.lastchange,t.priority,t.value_flags,t.description,t.error, t.expression,hg.groupid FROM triggers t,functions f,items i,hosts_groups hg WHERE hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid IN ('2','4','6','7','9','10','12') AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') ORDER BY lastchange DESC,t.lastchange DESC] [Unknown column 't.value_flags' in 'field list']
Error in query [SELECT e.* FROM events e JOIN (SELECT max(eventid) as lasteventid FROM events e WHERE 1=0 AND e.objectid BETWEEN 000000000000000 AND 099999999999999 AND e.object=0 AND e.value_changed=1 GROUP BY e.objectid) ee ON e.eventid=ee.lasteventid] [Unknown column 'e.value_changed' in 'where clause']