Help, I Have trouble upgrade 1.9.7 from 1.9.5!

[amj]

Hi,

I try to upgrade to 1.9.7 from 1.9.5.
I compile new binaries, and replace php front-end with a new one.

The zabbix_server successfully started, but in the zabbix front-end there are lot of errors:

Error in query [SELECT hin.* FROM host_inventory hin WHERE (hin.hostid IN ('10017')) ] [Table 'zabbix.host_inventory' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:594]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:596]
Error in query [SELECT hin.* FROM host_inventory hin WHERE (hin.hostid IN ('10055')) ] [Table 'zabbix.host_inventory' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:594]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:596]
Error in query [SELECT hin.* FROM host_inventory hin WHERE (hin.hostid IN ('10058')) ] [Table 'zabbix.host_inventory' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:594]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:596]

Error in query [SELECT im.*,s.sysmapid FROM icon_map im,sysmaps s WHERE im.iconmapid BETWEEN 000000000000000 AND 099999999999999 AND (s.sysmapid IN ('2')) AND im.iconmapid=s.iconmapid] [Table 'zabbix.icon_map' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:594]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:596]
Error in query [SELECT imp.* FROM icon_mapping imp WHERE 1=0 ] [Table 'zabbix.icon_mapping' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:594]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:596]
Undefined index: iconmapid [include/maps.inc.php:1022]
Undefined index: iconmapid [include/maps.inc.php:1035]
Undefined index: iconmapid [include/maps.inc.php:1259]

The missing table 'icon_mapping' wasn't exist in 1.9.5, but i found in 1.9.7 schema.sql.

How can I upgrade the database?

Thanks!

Best regards,
Gabor

[richlv]

there are no official database patches between development versions.

but there are unofficial ones for mysql :)

see http://www.zabbix.org/svn/zabbixorg/zabbix/upgrade_incremental/README

you can either add dbversion of version 1.9.5 to your database, or generate 1.9.5->1.9.7 patch. former might be more suggested as that would allow you to apply future patches much more easily

[amj]

there are no official database patches between development versions.

but there are unofficial ones for mysql :)

see http://www.zabbix.org/svn/zabbixorg/zabbix/upgrade_incremental/README

you can either add dbversion of version 1.9.5 to your database, or generate 1.9.5->1.9.7 patch. former might be more suggested as that would allow you to apply future patches much more easily

Thanks. It works.