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

Re: [Koha] Bulk Patron Images

[Indranil Das Gupta]

Hi Sandeep,

On Wed, Nov 13, 2013 at 3:47 PM, Sandeep Bhavsar
sandeep.bhav...@gmail.comwrote:

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