[Koha] Bulk Patron Images

[Sandeep Bhavsar]

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