[Koha-bugs] [Bug 16170] Pseudo foreign key in Items

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Mar 31 15:59:04 CEST 2016


--- Comment #9 from Marcel de Rooy <m.de.rooy at 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.

More information about the Koha-bugs mailing list