-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Blocker
-
None
-
Affects Version/s: 1.8, 1.9.0 (alpha)
-
Component/s: Server (S)
-
None
-
Environment:MySQL 5.0, Debian GNU/Linux
The SQL patch to migrate a MySQL database from Zabbix server 1.6.x to 1.8 (upgrades/dbpatches/1.8/mysql/patch.sql) did not work with MySQL 5.0 here. The following changes will make it work with 5.0:
– alter table graphs_items alter color varchar(6) DEFAULT '009600' NOT NULL;
alter table graphs_items alter color SET DEFAULT '009600';
alter table graphs_items change color color varchar(6) not null;
– alter table proxy_dhistory alter key_ varchar(255) DEFAULT '' NOT NULL;
– alter table proxy_dhistory alter value varchar(255) DEFAULT '' NOT NULL;
alter table proxy_dhistory alter key_ set default '';
alter table proxy_dhistory alter value set default '';
– alter table sysmaps_elements alter label varchar(255) DEFAULT '' NOT NULL;
alter table sysmaps_elements alter label set default '';
alter table sysmaps_elements change label label varchar(255) not null;