Erro no PHP

[munhos]

Tentei fazer a instalação do Zabbix 2.0.1 e agora logo que eu abro o dashboard está aparecendo duas mensagens de erro:

A primeira no topo, logo abaixo do botão "Dashboard":

Undefined index: severity_color_5 [include/page_header.php:158]
Undefined index: severity_color_4 [include/page_header.php:159]
Undefined index: severity_color_3 [include/page_header.php:160]
Undefined index: severity_color_2 [include/page_header.php:161]
Undefined index: severity_color_1 [include/page_header.php:162]
Undefined index: severity_color_0 [include/page_header.php:163]
Undefined index: server_check_interval [include/page_header.php:168]

E a outra no meio da página:

Error in query [SELECT DISTINCT h.hostid,h.name,hg.groupid FROM hosts h,hosts_groups hg WHERE (hg.groupid IN ('6','4')) AND hg.hostid=h.hostid AND hg.groupid BETWEEN 000000000000000 AND 099999999999999 AND h.status=0] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
Error in query [SELECT DISTINCT t.*,h.name AS hostname,h.host,h.hostid FROM triggers t,functions f,items i,hosts h WHERE t.triggerid BETWEEN 000000000000000 AND 099999999999999 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')) ) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND h.hostid=i.hostid] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]

Se alguém puder me ajudar eu agradeço.

Att.

Flávio

[Elins]

Tentei fazer a instalação do Zabbix 2.0.1 e agora logo que eu abro o dashboard está aparecendo duas mensagens de erro:

A primeira no topo, logo abaixo do botão "Dashboard":

Undefined index: severity_color_5 [include/page_header.php:158]
Undefined index: severity_color_4 [include/page_header.php:159]
Undefined index: severity_color_3 [include/page_header.php:160]
Undefined index: severity_color_2 [include/page_header.php:161]
Undefined index: severity_color_1 [include/page_header.php:162]
Undefined index: severity_color_0 [include/page_header.php:163]
Undefined index: server_check_interval [include/page_header.php:168]

E a outra no meio da página:

Error in query [SELECT DISTINCT h.hostid,h.name,hg.groupid FROM hosts h,hosts_groups hg WHERE (hg.groupid IN ('6','4')) AND hg.hostid=h.hostid AND hg.groupid BETWEEN 000000000000000 AND 099999999999999 AND h.status=0] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
Error in query [SELECT DISTINCT t.*,h.name AS hostname,h.host,h.hostid FROM triggers t,functions f,items i,hosts h WHERE t.triggerid BETWEEN 000000000000000 AND 099999999999999 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')) ) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND h.hostid=i.hostid] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]

Se alguém puder me ajudar eu agradeço.

Att.

Flávio

Boa tarde Flavio.
Não esta bem especificado, mas provavelmente voce fez upgrade do zabbix certo? Provavelmente nao foi feito upgrade da base de dados com o script que é fornecido pelos pacotes da versao 2.xx. Siga o procedimento abaixo retirado da documentacao do zabbix que funcionará.

6 Upgrade the database

Before you upgrade:

Make sure the database user has enough permissions (create table, drop table, create index, drop index)
Make sure you have enough free disk space.

Database upgrade scripts are located in the upgrades/dbpatches/2.0/<db engine> directory. Run the scripts:

MySQL: upgrades/dbpatches/2.0/mysql/patch.sql
PostgreSQL: upgrades/dbpatches/2.0/postgresql/patch.sql
Oracle: upgrades/dbpatches/2.0/oracle/patch.sql
IBM DB2: upgrades/dbpatches/2.0/ibm_db2/patch.sql

These scripts are only for upgrading Zabbix 1.8.x to 2.0! For upgrading from earlier versions first use upgrade scripts from Zabbix 1.6.x or Zabbix 1.8.x.