https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16170
--- Comment #9 from Marcel de Rooy <m.de.r...@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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
