Magdalena Söderqvist <[email protected]> > 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/ _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha

