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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha