Bug 21394

Summary: after hold is put into place, can not check out to patron and hold can not be removed
Product: Koha Reporter: Kimberle <kmadden>
Component: Hold requestsAssignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: gmcharlt
Version: 18.05   
Hardware: PC   
OS: Windows   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Crowdfunding committed: 0
Crowdfunding contact: Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Kimberle 2018-09-21 16:08:46 UTC
once Hold is confirmed and I try to check it out to a student, a message pops up saying software error 'duplicate id' 

at that point I can't remove hold in any of the different screens, the book seems to be locked and can no longer be checked out, removed or anything.
Comment 1 Katrin Fischer 2018-10-28 18:08:30 UTC
Hi Kimberle,

this indicates a problem in your data, there is the same reserve_id for an active hold as an already fulfilled hold in your database.

Please check About > System information for more information and also see here:
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix

The easiest fix is to delete the duplicate id from the old_reserves table with SQL. Then you will be able to fill the other hold.

I am marking invalid as this is a database issue that needs to be fixed on system side.