[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

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Failed QA

--- Comment #9 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
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!

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.

2) Change all values
- The location is missing from the display summary table (empty) - BOO!
- When editing, the home library shows as 'unchanged' - BOO!

Sorry for the BOOs, but I think this still needs some work.

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