[Bug 20283] New: Editing a course item for an inactive course affects the item fields directly
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 Bug ID: 20283 Summary: Editing a course item for an inactive course affects the item fields directly Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Course reserves Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org When adding an item to course reserves the values in the items and course_items tables are swapped e.g. items.holdingbranch becomes course_items.holdingbranch and vice versa. When a course is marked inactive, the values are swapped back. When editing an inactive course we modify item values directly. This seems to be because we don't check if the course is active or not. When a course is active ti is correct to modify the items, but if inactive we should only modify course_items To recreate: 1 - Find/create an item with existing values for: item type collection code shelving location holding library staff/public note 2 - Add this item to an active course in course reserves, change all the values 3 - Make the course inactive 4 - Edit the course item, changing all the values 5 - Save and note the changes did not populate to the course reserve 6 - View the item, note the item was changed 7 - Edit the course again, note the dropdowns show the course item values, not the new item values I think we have two options: 1 - Check if a course it active when modifiying a course reserve and adjust the correct table 2 - Don't allow editing of items for inactive courses -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org, | |kyle.m.hall@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 nchan@cca.edu changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nchan@cca.edu --- Comment #1 from nchan@cca.edu --- I'm having the same issue. Additionally, when deleting an inactive course that contains reserve items, the values that are normally changed when the course is marked "active" are changed permanently in the item record. Course reserve class is inactive. Item in the course reserve list has correct location, item type, and shelving location. Course reserve class is deleted (due to inactivity). Item that was listed in the course reserve list now has a location status of "reserves," item type of "reserve," and location is changed based on branch where the course reserves were held. Switching the course to "active" before deleting the course also causes the same result. This is pretty frustrating to go back and fix manually due to the number of items that may be in a course (and once the course is deleted, it may be hard to track down the original list). -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 Myka Kennedy Stephens <mkstephens@lancasterseminary.edu> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mkstephens@lancasterseminar | |y.edu --- Comment #2 from Myka Kennedy Stephens <mkstephens@lancasterseminary.edu> --- Yes, this bug creates huge problems if one does not know it exists. The only way I have figured out to avoid items being permanently changed to their course reserve status when a course is deleted or when an item is deleted from a course is to do the following: 1. Make sure the course being deleted is enabled 2. Edit the item being deleted from the course to leave everything unchanged 3. Delete the item from the course This workaround probably requires the same amount of effort as manually changing each item back to its original status after deleting a course from course reserves. The better way to go is probably to note all the barcodes before deleting the course and then use the batch item modification tool after the fact. Please find a fix for this bug! Thank you in advance. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- I have tried to write a fix but I did not manage to write the tests. There is a lack of tests which makes new tests hard to write. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 Kelly McElligott <kelly@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kelly@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 Marjorie Barry-Vila <marjorie.barry-vila@collecto.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |marjorie.barry-vila@collect | |o.ca -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 Séverine Queune <severine.queune@bulac.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |severine.queune@bulac.fr -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20283 Myka Kennedy Stephens <mkstephens@lancasterseminary.edu> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #4 from Myka Kennedy Stephens <mkstephens@lancasterseminary.edu> --- I'm not having trouble with this anymore and think it was resolved by bug 24772 and bug 23727. I cannot recreate the original issue. Marking as resolved for now. Please feel free to reopen if I'm wrong and it's still a bug. *** This bug has been marked as a duplicate of bug 23727 *** -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org