http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305
--- Comment #7 from Mason James <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
