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@liblime.com ReportedBy: oleonard@myacpl.org QAContact: koha-bugs@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.