Cannot add or update a child row

[GoogleCodeExporter]

This issue tracker is for sigplus sigplus-1.5.0.186
J.3.1

Error
Cannot add or update a child row: a foreign key constraint fails 
(`sql-1`.`fw_sigplus_data`, CONSTRAINT `fw_sigplus_data_ibfk_2` FOREIGN KEY 
(`propertyid`) REFERENCES `fw_sigplus_property` (`propertyid`) ON DELETE 
CASCADE) SQL=INSERT INTO `fw_sigplus_data` (`propertyid`,`textvalue`,`imageid`) 
VALUES 
(0,'905721.jpg',80),(0,'1371884171',80),(0,'67761',80),(0,'2',80),(0,'image/jpeg
',80),(93,'http://www.dreamstime.com/-image1905721',80),(103,'72/1',80),(104,'72
/1',80),(115,'2',80),(159,'1',80),(238,'(c) Markz | 
Dreamstime.com',80),(287,'http://www.dreamstime.com/-image1905721',80) ON 
DUPLICATE KEY UPDATE `propertyid` = VALUES(`propertyid`), `textvalue` = 
VALUES(`textvalue`), `imageid` = VALUES(`imageid`)

------------------

Best Regards!

Original issue reported on code.google.com by ten.mari...@gmail.com on 22 Jun 2013 at 7:06

Attachments:

• dreamsteam.zip

[GoogleCodeExporter]

access path to the file \ images \ _stock

Original comment by ten.mari...@gmail.com on 22 Jun 2013 at 7:12

[GoogleCodeExporter]

os x 10.7, 10.8

Original comment by ten.mari...@gmail.com on 22 Jun 2013 at 10:45

[GoogleCodeExporter]

The issue is related to the image "bausteine", which has both IPTC and EXIF 
metadata. Other images have no metadata and cannot trigger the database 
duplicate row problem indicated above.

Unfortunately, I do not seem to be able to reproduce the issue in sigplus 
1.5.0.188 (Windows), which appears to work correctly.

Original comment by huny...@gmail.com on 14 Sep 2013 at 6:16

[GoogleCodeExporter]

the updates do not see the problem, I'll be watching.

Original comment by ten.mari...@gmail.com on 16 Sep 2013 at 5:05

[GoogleCodeExporter]

I am labeling this issue as "Fixed". Please let me know if the problem pops up 
again, and I will re-open the issue.

Original comment by huny...@gmail.com on 22 Sep 2013 at 7:21

• Changed state: Fixed

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

OK. thx.

Original comment by ten.mari...@gmail.com on 8 Oct 2013 at 10:37

[GoogleCodeExporter]

Hi everybydy, i have a  big trouble with my sigplus galley , when i upload any 
image joomla show this error (it's very importan for my job please help me):

error
SQL=INSERT INTO `a8ruk_sigplus_data` (`propertyid`,`textvalue`,`imageid`) 
VALUES 
(0,'imagen3.JPG',110),(0,'1411925233',110),(0,'42823',110),(0,'2',110),(0,'image
/jpeg',110),(95,'NIKON CORPORATION',110),(96,'NIKON 
D5200',110),(104,'300/1',110),(105,'300/1',110),(116,'2',110),(119,'Ver.1.00 
',110),(120,'2014:04:13 
11:02:48',110),(160,'2',110),(250,'832',110),(300,'0',110),(301,'0',110),(302,'0
',110),(303,'1/1',110),(304,'18',110),(305,'0',110),(306,'1',110),(307,'0',110),
(308,'0',110),(309,'0',110),(311,'0',110),(240,'10/600',110),(241,'40/10',110),(
248,'0',110),(251,'400',110),(253,'0230',110),(254,'2014:04:13 
11:02:48',110),(255,'2014:04:13 11:02:48',110),(256,'Y, Cb, 
Cr',110),(257,'2/1',110),(261,'0/6',110),(262,'36/10',110),(264,'5',110),(265,'0
',110),(266,'16',110),(267,'180/10',110),(283,'ASCII\0\0\0 
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',110),(28
4,'30',110),(285,'30',110),(286,'30',110),(292,'0100',110),(293,'1',110),(294,'5
12',110),(295,'768',110),(280,'2',110),(298,'Digital Still 
Camera',110),(299,'Directly photographed 
image',110),(237,'\0\0\0

',110),(0,'\0\0',110),(0,'400',110) ON DUPLICATE 
KEY UPDATE `propertyid` = VALUES(`propertyid`), `textvalue` = 
VALUES(`textvalue`), `imageid` = VALUES(`imageid`)

Original comment by Crhistia...@gmail.com on 28 Sep 2014 at 5:34

[GoogleCodeExporter]

For some rows in the table a8ruk_sigplus_data corresponding to the column 
propertyid, sigplus appears to use the primary key value 0, which is not 
permitted (the column value propertyid must always be a positive integer):

(0,'imagen3.JPG',110),
(0,'1411925233',110),
(0,'42823',110),
(0,'2',110),
(0,'image/jpeg',110),

The quick workaround is to strip all metadata from the image that triggers the 
error. In order to help us find a true solution to the problem, please tell us 
the exact sigplus version you use (and upgrade to the latest unless you already 
have it) and attach the image that causes trouble. Thanks in advance.

Original comment by huny...@gmail.com on 28 Sep 2014 at 5:46