http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #7 from Mason James <mtj@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.