https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16170 --- Comment #9 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to Jonathan Druart from comment #8)
t/db_dependent/Items.t ................................. 1/9 DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_ut`.`items`, CONSTRAINT `items_ibfk_4` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement "INSERT INTO `items` ( `biblioitemnumber`, `itype`) VALUES ( ?, ? )" with ParamValues: 0='88', 1='ITEM_LEVEL'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834.
Good catch, but what now? This is a good example of our bad database design. DBIx tries to insert records in items based on biblioitemnumber but ignores the biblionumber one level up. We can adjust this statement of course, but it is a workaround.. -- You are receiving this mail because: You are watching all bug changes.