Hi,
I'm trying to apply schema, data and images to postgresql 9.1 on ubuntu 12.04. I'm following the instructions at:
https://www.zabbix.com/wiki/howto/in...8_on_debian_50)
I'm hitting an error when running:
$ cat database/postgresql/data.sql | psql zabbix
Error (truncated):
INSERT 0 1
INSERT 0 1
ERROR: insert or update on table "sysmaps_elements" violates foreign key constraint "c_sysmaps_elements_2"
DETAIL: Key (iconid_off)=(185) is not present in table "images".
ERROR: current transaction is aborted, commands ignored until end of transaction block
if someone can help me to move past this error that will be great
Regards,
Dave
I'm trying to apply schema, data and images to postgresql 9.1 on ubuntu 12.04. I'm following the instructions at:
https://www.zabbix.com/wiki/howto/in...8_on_debian_50)
I'm hitting an error when running:
$ cat database/postgresql/data.sql | psql zabbix
Error (truncated):
INSERT 0 1
INSERT 0 1
ERROR: insert or update on table "sysmaps_elements" violates foreign key constraint "c_sysmaps_elements_2"
DETAIL: Key (iconid_off)=(185) is not present in table "images".
ERROR: current transaction is aborted, commands ignored until end of transaction block
if someone can help me to move past this error that will be great

Regards,
Dave
Comment