[Koha-bugs] [Bug 1398] New: Branch management not working with returns
bugzilla-daemon at pippin.metavore.com
bugzilla-daemon at pippin.metavore.com
Sat Aug 18 16:26:26 CEST 2007
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1398
Summary: Branch management not working with returns
Product: Koha
Version: rel_3_0
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P3
Component: Circulation
AssignedTo: chris.cormack at liblime.com
ReportedBy: oleonard at myacpl.org
QAContact: koha-bugs at nongnu.org
I'm not sure what's happening here, but here's the sequence: I have a new
install of Koha, logged in as the user with which Koha was installed. I
successfully checked out an item to a patron, but when I tried to return the
item Koha displayed an error message: "The document [book title] () Must be
returned to his homebranch(MAIN)"
Koha says I'm "Logged in as: oleonard at NO_LIBRARY_SET"
I went to selectbranchprinter.pl, chose "Main Library" (it was selected
anyway), and submitted. I tried to return the book again and got the same
error. Koha still says I'm logged in at NO_LIBRARY_SET.
Here are what I hope are the relevant errors in the log:
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`mydatabase/items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY
(`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at
/path/to/koha/intranet/modules/C4/Circulation.pm line 1014.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`mydatabase/items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY
(`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at
/path/to/koha/intranet/modules/C4/Circulation.pm line 1920.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`mydatabase/branchtransfers`, CONSTRAINT
`branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches`
(`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE) at
/path/to/koha/intranet/modules/C4/Biblio.pm line 460.
was transfered at /path/to/koha/intranet/modules/C4/Circulation.pm line 1290.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`mydatabase/items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY
(`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at
/path/to/koha/intranet/modules/C4/Circulation.pm line 1920.
DBD::mysql::st execute failed: Column 'tobranch' cannot be null at
/path/to/koha/intranet/modules/C4/Biblio.pm line 460.
was transfered at /path/to/koha/intranet/modules/C4/Circulation.pm line 1290.
------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.
More information about the Koha-bugs
mailing list