-
Change Request
-
Resolution: Won't fix
-
Minor
-
None
-
2.0.2, 2.0.3
-
mysql, but suspect other SQL server too
frontend
If I have a Zabbix environment with old/custom images uploaded already, I cannot import images.sql because it tries to overwrite old imageid
I fixed this, by setting imageid column with AUTO_INCREMENT as follows (image_table_create.sql):
mysql> describe images;
----------------------------------------------------------+
Field | Type | Null | Key | Default | Extra |
----------------------------------------------------------+
imageid | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
imagetype | int(11) | NO | MUL | 0 | |
name | varchar(64) | NO | 0 | ||
image | longblob | NO | NULL |
----------------------------------------------------------+
4 rows in set (0.00 sec)
mysql>
and images.sql should have not imageid definitions, like this line (images_fixed.sql):
INSERT INTO `images` (`imagetype`,`name`,`image`) VALUES (1,'Cloud_(128)',0x89504E470D0A1A [..........]);