http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1478 Summary: Constraints might be too severe Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: major Priority: P3 Component: Acquisitions (Simple) AssignedTo: paul.poulain@free.fr ReportedBy: jmf@liblime.com QAContact: koha-bugs@nongnu.org I think we need to consider whether placing a constraint on the items table agains the branches table is really a good idea. It will mean that any time you import a record that has a branch that isn't listed in the branches table, the query will fail, it will be in the MARC, but not in the items table: .[Sat Oct 6 09:13:54 2007] bulkmarcimport.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`jmf_koha/items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at C4/Biblio.pm line 3600. 11 MARC records done in 1.70784592628479 seconds ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.