---- 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