[Koha-bugs] [Bug 22630] Allow to change homebranch in course reserves

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22630

--- Comment #10 from Liz Rea <wizzyrea at gmail.com> ---
(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.