Topic: [SOLVED] Zabbix upgrade from 1.8 to 2.0.3

[Jáder]

Daniel / all others

I'm using Zabbix 1.8 (rpms from FWS) and last night I try to upgrade to 2.0.3 running yum.
Upgrade went fine (no errors) but frontend do not work.

I see multiple errors like:

Code: [Select]

Undefined index: severity_color_5 [include/page_header.php:160]
Error in query [SELECT  DISTINCT  h.hostid,h.name,hg.groupid FROM hosts h,hosts_groups hg WHERE  (hg.groupid IN ('9','6','12','13','11','10','14','7','4'))  AND hg.hostid=h.hostid AND h.status=0] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [.php:570]

so appears BD was not upgraded.

I have a backup... but I'd love to ear some guidance before start to change anything

Regards

Jáder

[Jáder]

Because I got no answer I moved forward...
Just run
/usr/share/doc/zabbix-server-2.0.3/dbpatches/2.0/mysql/upgrade
using my zabbix database as parameter and everything was back to normal.

I hope this help someone else!

Regards.

Jáder