[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-bugs] [Bug 1478] New: Constraints might be too severe
From: |
bugzilla-daemon |
Subject: |
[Koha-bugs] [Bug 1478] New: Constraints might be too severe |
Date: |
Sat, 6 Oct 2007 07:16:44 -0700 (PDT) |
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: address@hidden
ReportedBy: address@hidden
QAContact: address@hidden
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.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-bugs] [Bug 1478] New: Constraints might be too severe,
bugzilla-daemon <=