https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37174
Bug ID: 37174
Summary: Patron’s checkout summary reports "0 of 0 renewals
remaining" while circulation rules allow 3 renewals
Change sponsored?: ---
Product: Koha
Version: 24.05
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: Circulation
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected], [email protected]
Created attachment 168039
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=168039&action=edit
Data before (which fails) and after (which works) assigning branchcode to all
records
After upgrading from 23.11 to 24.05, renewals failed to work correctly using
Circulation > Renew, the Renew option on the menu bar, or the Patron’s checkout
summary. For example, the patron’s checkout summary reported all items as "Not
Renewable (0 of 0 renewals remaining)" while the circulation rule for this
patron category allows 3.
I found an earlier bug issue from 2017 (Koha 16.11.04) in which deleting and
recreating all categories resolved this issue
(https://koha.katipo.co.narkive.com/PWWM7AWH/all-items-not-renewable). I
created a new category, assigned a user to this category, and checked the
Patron screen. For this single user, renewals returned to working properly.
To avoid the work this solution would require, I checked the contents of table
"circulation_rules". I found that branchcode was set to our correct code
("FCC") for the new entry, but was NULL for many of the properties in existing
categories, including the patron category having the problem. I assigned the
correct value to all entries using "UPDATE circulation_rules SET branchcode =
'FCC' WHERE branchcode IS NULL;" and the patron summary properly reported "(x
of 3 renewals)" and allowed renewals. Checking a data backup from 2023, the
NULL values existed in 23.11, so this data pre-existed the upgrade to 24.05 but
the renewals operated correctly with this data in the earlier version.
A backup of the circulation_rules table data before and after the change are
attached. This was the only table modified to correct the symptom.
--
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]
https://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/
