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

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16170

--- 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.