Basics:
One important bit of information I forgot to include originally is that I'm running 1.8.15 on the same system. 1.8 is using a DB named zabbix and 2.0.3 is using a DB named zabbix2.
I dumped my existing database and restored it to a new db called zabbix2. Then I ran patch.sql against my new database copy. (a 4 hour process) When I bring up the new GUI I am getting the following errors on the monitoring->dashboard page. Anyone have a clue what is wrong?
Error in query [SELECT DISTINCT t.*,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 ('25','26','27','28','29','34','31','15','24','30' ,'21','18','11','33','13','8','20','23','12','32', '2','17','6','16','7','14','5','19','9','3','4')) AND NOT EXISTS ( SELECT ff.functionid FROM functions ff WHERE ff.triggerid=t.triggerid AND EXISTS ( SELECT ii.itemid FROM items ii,hosts hh WHERE ff.itemid=ii.itemid AND hh.hostid=ii.hostid AND ( ii.status<>0 OR hh.status<>0 ) ) ) AND t.status=0 AND ( (t.value IN ('1')) AND (t.flags IN ('0','4')) ) ORDER BY lastchange DESC,t.lastchange DESC] [Unknown column 't.flags' in 'where clause']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]
Error in query [SELECT DISTINCT h.hostid,h.name,f.triggerid FROM hosts h,functions f,items i WHERE 1=0 AND h.hostid=i.hostid AND f.itemid=i.itemid AND h.status IN (0,1,3)] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]
- Ubuntu 12.04 LTS
- MySQL 5.5.24-0ubuntu0.12.04.1
- Zabbix 2.0.3
One important bit of information I forgot to include originally is that I'm running 1.8.15 on the same system. 1.8 is using a DB named zabbix and 2.0.3 is using a DB named zabbix2.
I dumped my existing database and restored it to a new db called zabbix2. Then I ran patch.sql against my new database copy. (a 4 hour process) When I bring up the new GUI I am getting the following errors on the monitoring->dashboard page. Anyone have a clue what is wrong?
Error in query [SELECT DISTINCT t.*,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 ('25','26','27','28','29','34','31','15','24','30' ,'21','18','11','33','13','8','20','23','12','32', '2','17','6','16','7','14','5','19','9','3','4')) AND NOT EXISTS ( SELECT ff.functionid FROM functions ff WHERE ff.triggerid=t.triggerid AND EXISTS ( SELECT ii.itemid FROM items ii,hosts hh WHERE ff.itemid=ii.itemid AND hh.hostid=ii.hostid AND ( ii.status<>0 OR hh.status<>0 ) ) ) AND t.status=0 AND ( (t.value IN ('1')) AND (t.flags IN ('0','4')) ) ORDER BY lastchange DESC,t.lastchange DESC] [Unknown column 't.flags' in 'where clause']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]
Error in query [SELECT DISTINCT h.hostid,h.name,f.triggerid FROM hosts h,functions f,items i WHERE 1=0 AND h.hostid=i.hostid AND f.itemid=i.itemid AND h.status IN (0,1,3)] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]
Comment