Magdalena Söderqvist <soderqvist@sipri.org>
koha@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/