[Koha-bugs] [Bug 1398] New: Branch management not working with returns

[bugzilla-daemon at pippin.metavore.com]

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.