https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27313 Bug ID: 27313 Summary: bulkmarcimport.pl -d foreign key constraint fails Change sponsored?: --- Product: Koha Version: 20.11 Hardware: All OS: Linux Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs@lists.koha-community.org Reporter: davewood@gmx.at QA Contact: testopia@bugs.koha-community.org CC: robin@catalyst.net.nz 11:41 < cait1> hm can you file a bug report please? 11:41 < cait1> we have tightened some things in the db, this might be a side effect 11:41 < cait1> but basically... you have issues 11:41 < cait1> Ausleihen 11:41 < cait1> so it's correct in failing 11:41 < cait1> if you truncate the issues first this is probably going to work better 11:42 < cait1> the script is not supposed to be used once you have loaded other transactional data atm 11:42 < cait1> for the same data... perl /usr/share/koha/bin/migration_tools/bulkmarcimport.pl -d -m=*MARCXML* -file test.marc.xml deleting biblios DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha_libelle`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) [for Statement "DELETE FROM biblio"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 174. DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha_libelle`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) [for Statement "DELETE FROM biblioitems"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 176. DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha_libelle`.`issues`, CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE) [for Statement "DELETE FROM items"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 178. .DBD::mysql::db begin_work failed: Already in a transaction at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1588, <GEN24> line 2. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.