[Koha] bulkmarcimport-problems!

MJ Ray mjr at phonecoop.coop
Thu Feb 23 08:14:48 NZDT 2012


Magdalena Söderqvist <soderqvist at sipri.org>
> koha at kohatest:/usr/share/koha/bin/migration_tools$ perl 
> ./bulkmarcimport.pl -d -match 999c -commit 1000 -v -v -file 
> /root/40_77000_2.mrc 
> deleting biblios 
> DBD::mysql: b do failed: Cannot delete or update a parent row: a 
> foreign key constraint fails (`koha`.`issues`, CONSTRAINT 
> `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` 
> (`itemnumber`) ON UPDATE CASCADE) at ./bulkmarcimport.pl line 96. 

Well, -d deletes the old biblios before importing the file, but the
database is refusing because some of them have issued items.

> .Use of uninitialized value $recorddata in pattern match (m//) at 
> ./bulkmarcimport.pl line 392, <GEN16> line 1. 
> unable to search the database for duplicates : No query entered at 
> ./bulkmarcimport.pl line 217, <GEN16> line 1. 

I got similar errors when trying to use -match earlier today.  I
thought it was just my mistake, but maybe it's not.  Does anyone have
an insight into this?  I think I'll next get chance to investigate it
next Wednesday, which is quite a wait.

Hope that informs,
-- 
MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op.
http://koha-community.org supporter, web and library systems developer.
In My Opinion Only: see http://mjr.towers.org.uk/email.html
Available for hire (including development) at http://www.software.coop/


More information about the Koha mailing list