Bug 41698

Summary: Add maintenance script to revert found holds for items currently checked out
Product: Koha Reporter: Kyle M Hall (khall) <kyle>
Component: Command-line UtilitiesAssignee: Kyle M Hall (khall) <kyle>
Status: Needs Signoff --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: hebah, robin
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37694
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: Small patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Bug 41698 - Add maintenance script to revert found holds for items currently checked out
Bug 41698 - Add maintenance script to revert found holds for items currently checked out
Bug 41698: Add maintenance script to revert found holds for items currently checked out

Description Kyle M Hall (khall) 2026-01-23 19:08:12 UTC
For reasons unknown, it is possible to get into a situation where an item is both checked out to one patron and associated with a found hold for another patron. We should add a script to Koha to fix items in this situation by reverting the found holds.
Comment 1 Kyle M Hall (khall) 2026-01-23 19:10:23 UTC
Created attachment 191978 [details] [review]
Bug 41698 - Add maintenance script to revert found holds for items currently checked out

For reasons unknown, it is possible to get into a situation where an item is both checked out to one patron and associated with a found hold for another patron. We should add a script to Koha to fix items in this situation by reverting the found holds.

Test Plan:
1) Check an item out to a patron
2) Place an item specific hold for another patron
3) Manually set the priority to 0 and found to "W" for that hold
4) Run misc/maintenance/fix_holds_waiting_and_issued.pl
5) Note the hold has been reverted!
Comment 2 Kyle M Hall (khall) 2026-01-23 19:15:35 UTC
Created attachment 191979 [details] [review]
Bug 41698 - Add maintenance script to revert found holds for items currently checked out

For reasons unknown, it is possible to get into a situation where an item is both checked out to one patron and associated with a found hold for another patron. We should add a script to Koha to fix items in this situation by reverting the found holds.

Test Plan:
1) Check an item out to a patron
2) Place an item specific hold for another patron
3) Manually set the priority to 0 and found to "W" for that hold
4) Run misc/maintenance/fix_holds_waiting_and_issued.pl
5) Note the hold has been reverted!
Comment 3 Kyle M Hall (khall) 2026-01-23 19:17:01 UTC
Created attachment 191980 [details] [review]
Bug 41698: Add maintenance script to revert found holds for items currently checked out

For reasons unknown, it is possible to get into a situation where an item is both checked out to one patron and associated with a found hold for another patron. We should add a script to Koha to fix items in this situation by reverting the found holds.

Test Plan:
1) Check an item out to a patron
2) Place an item specific hold for another patron
3) Manually set the priority to 0 and found to "W" for that hold
4) Run misc/maintenance/fix_holds_waiting_and_issued.pl
5) Note the hold has been reverted!