[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Dec 9 04:24:48 CET 2015


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #7 from Mason James <mtj at kohaaloha.com> ---
(In reply to june from comment #5)
> I got this error for SIP checkout although the item has been successfully
> checked out and display available status at the detail page.
> 
> DBD::mysql::st execute failed: Cannot add or update a child row: a foreign
> key constraint fails (`koha_dev_koha`.`items`, CONSTRAINT `items_ibfk_3`
> FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE
> CASCADE) at C4/Items.pm line 2384.
> ERROR in _koha_modify_item UPDATE items SET
> issues=?,datelastborrowed=?,holdingbranch=?,itemlost_on=?,itemlost=?,
> onloan=? WHERE itemnumber=?: Cannot add or update a child row: a foreign key
> constraint fails (`koha_dev_koha`.`items`, CONSTRAINT `items_ibfk_3` FOREIGN
> KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE
> CASCADE) at C4/Items.pm line 2387.

^... i think that error is caused by your item having a $branchcode that does
not exist in the 'branches' table?

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list