Hi,
I'm upgrading from 2.0.9 to 2.2, when I start "zabbix_server" for the first time it gives the following error updating Database:
5436:20131118:124512.378 ODBC: NO
5436:20131118:124512.378 SSH2 support: YES
5436:20131118:124512.378 IPv6 support: YES
5436:20131118:124512.378 ******************************
5436:20131118:124512.378 using configuration file: /usr/local/etc/zabbix_server.conf
5436:20131118:124512.383 current database version (mandatory/optional): 02010164/02010164
5436:20131118:124512.383 required mandatory version: 02020000
5436:20131118:124512.383 starting automatic database upgrade
5436:20131118:124512.499 [Z3005] query failed: [1005] Can't create table 'zabbix.#sql-14d8_13' (errno: 150) [alter table interface_discovery add constraint c_interface_discovery_1 foreign key (interfaceid) references interface (interfaceid) on delete cascade]
5436:20131118:124512.499 database upgrade failed
I'm upgrading from 2.0.9 to 2.2, when I start "zabbix_server" for the first time it gives the following error updating Database:
5436:20131118:124512.378 ODBC: NO
5436:20131118:124512.378 SSH2 support: YES
5436:20131118:124512.378 IPv6 support: YES
5436:20131118:124512.378 ******************************
5436:20131118:124512.378 using configuration file: /usr/local/etc/zabbix_server.conf
5436:20131118:124512.383 current database version (mandatory/optional): 02010164/02010164
5436:20131118:124512.383 required mandatory version: 02020000
5436:20131118:124512.383 starting automatic database upgrade
5436:20131118:124512.499 [Z3005] query failed: [1005] Can't create table 'zabbix.#sql-14d8_13' (errno: 150) [alter table interface_discovery add constraint c_interface_discovery_1 foreign key (interfaceid) references interface (interfaceid) on delete cascade]
5436:20131118:124512.499 database upgrade failed