Error creating data: 1.9.3

[exkg]

Hi,

We have errors loading first data in zabbix-1.9.3:

[root@CentOS tmp]# mysqladmin create zbx193
[root@CentOS tmp]# mysql zbx193 < /tmp/zabbix-1.9.3/create/schema/mysql.sql   

[root@CentOS tmp]# mysql zbx193 < /tmp/zabbix-1.9.3/create/data/data.sql 
ERROR 1452 (23000) at line 12215: Cannot add or update a child row: a foreign key constraint fails (`zbx193/sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))

[root@CentOS tmp]# mysql zbx193 < /tmp/zabbix-1.9.3/create/data/images_mysql.sql

[]s,
Luciano

[exkg]

Hi,

The same error in trunk (revision 18803):

[root@CentOS zabbix-1.9.4]# mysql zbx193 < /tmp/zabbix-1.9.4/create/schema/mysql.sql 

[root@CentOS zabbix-1.9.4]# mysql zbx193 < /tmp/zabbix-1.9.4/create/data/data.sql 
ERROR 1452 (23000) at line 12215: Cannot add or update a child row: a foreign key constraint fails (`zbx193/sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))

[root@CentOS zabbix-1.9.4]# mysql zbx193 < /tmp/zabbix-1.9.4/create/data/images_mysql.sql

[zalex_ua]

Sequence of DB creation is changed, read this.
Documentation page is updated, but i think need to add a huge note to this page too.

[zalex_ua]

heh, additional note added.

[exkg]

my fault ...

[root@CentOS ~]# mysqladmin drop zbx193         
[root@CentOS ~]# mysqladmin create zbx193                                             
[root@CentOS ~]# mysql zbx193 < /tmp/zabbix-1.9.4/create/schema/mysql.sql         
[root@CentOS ~]# mysql zbx193 < /tmp/zabbix-1.9.4/create/data/images_mysql.sql 
[root@CentOS ~]# mysql zbx193 < /tmp/zabbix-1.9.4/create/data/data.sql

All things are ok ... after read a little.


[]s,
Luciano