Respected all I am using Mr. A. J. Tomson's python script for bulk uploading of patron images (9000). I have successfully run the python program and created the zip file but while uploading the same, facing the below error. [Wed Nov 13 20:32:59 2013] [error] [client 10.1.6.30] [Wed Nov 13 20:32:59 2013] picture-upload.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_koha`.`patronimage`, CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/lib/C4/Members.pm line 1837., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl [Wed Nov 13 20:32:59 2013] [error] [client 10.1.6.30] [Wed Nov 13 20:32:59 2013] picture-upload.pl: Error returned inserting 2008220483.image/png. at /usr/share/koha/lib/C4/Members.pm line 1838., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl [Wed Nov 13 20:32:59 2013] [error] [client 10.1.6.30] [Wed Nov 13 20:32:59 2013] picture-upload.pl: Database returned error: Cannot add or update a child row: a foreign key constraint fails (`koha_koha`.`patronimage`, CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/intranet/cgi-bin/tools/picture-upload.pl line 267., referer: http://10.1.6.14:9001/cgi-bin/koha/tools/picture-upload.pl -- *Regards * *Sandeep Bhavsar* B.com, M.Lib.I.Sc SET, M.Phil, American Library Association - FERA 2011 fellow Librarian Dr. V N Bedekar Institute of Management Studies Thane (W) 400601 Mumbai INDIA Mobile : 9987049099 www.vpmthane.org
Hi Sandeep, On Wed, Nov 13, 2013 at 3:47 PM, Sandeep Bhavsar <sandeep.bhavsar@gmail.com>wrote:
Respected all
I am using Mr. A. J. Tomson's python script for bulk uploading of patron images (9000). I have successfully run the python program and created the
First of all, Mr. Tomson's python script is not a part of the standard Koha suite of tools. So for any support for use of it, the best person would be Mr. Tomson :) [Wed Nov 13 20:32:59 2013] [error] [client 10.1.6.30] [Wed Nov 13 20:32:59
2013] picture-upload.pl: Error returned inserting 2008220483.image/png. at
the error tells you precisely where it barfed - "Error returned inserting 2008220483.image/png" Check for existing duplicates which is triggering the FK constraint. hope this helps -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
participants (2)
-
Indranil Das Gupta -
Sandeep Bhavsar