Bug 1398 - Branch management not working with returns
Summary: Branch management not working with returns
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: master
Hardware: All All
: P3 normal (vote)
Assignee: Chris Cormack
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-08-18 07:26 UTC by Owen Leonard
Modified: 2012-10-25 23:31 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Who signed the patch off:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cormack 2010-05-21 00:30:00 UTC


---- Reported by oleonard@myacpl.org 2007-08-18 07:26:26 ----

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.



---- Additional Comments From jmf@liblime.com 2007-10-04 13:15:35 ----

can't use the kohaadmin to circulate things, use a normal circ user.



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 00:30 UTC  ---

This bug was previously known as _bug_ 1398 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=1398

Actual time not defined. Setting to 0.0