https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22630
--- Comment #10 from Liz Rea <[email protected]> --- (In reply to Katrin Fischer from comment #9) > Ok, I did: > > - Apply the patch > - restart_all > - updatedatabase > - dbic > - restart_all > > > Then I added 2 items to course reserves: > > 1) Leaving all unchanged > - Everything shows up in the table correctly - OK > - When editing, they all show "Leave unchanged" - OK > - But: change all settings, they are not saved! - BOO! I just tested this again, and they were saved? > > Logs show: > > DBD::mysql::st execute failed: Cannot add or update a child row: a foreign > key constraint fails (`koha_kohadev`.`items`, CONSTRAINT `items_ibfk_2` > FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE > CASCADE) [for Statement "UPDATE items SET > itype=?,homebranch=?,holdingbranch=?,ccode=?,permanent_location=?,location=? > WHERE itemnumber=?" with ParamValues: 0="", 1="", 2="", 3="", 4="", 5="", > 6=14] at /home/vagrant/kohaclone/C4/Items.pm line 1811. > ERROR in _koha_modify_item UPDATE items SET > itype=?,homebranch=?,holdingbranch=?,ccode=?,permanent_location=?,location=? > WHERE itemnumber=?: Cannot add or update a child row: a foreign key > constraint fails (`koha_kohadev`.`items`, CONSTRAINT `items_ibfk_2` FOREIGN > KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) > at /home/vagrant/kohaclone/C4/Items.pm line 1814. I did not receive this message. > > 2) Change all values > - The location is missing from the display summary table (empty) - BOO! This appears on my screen, between collection and home library? > - When editing, the home library shows as 'unchanged' - BOO! Legit, I missed this. :( > > Sorry for the BOOs, but I think this still needs some work. It does, but possibly not as much as all of this. -- You are receiving this mail because: 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/
