Bug 21394 - after hold is put into place, can not check out to patron and hold can not be removed
Summary: after hold is put into place, can not check out to patron and hold can not be...
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Hold requests (show other bugs)
Version: 18.05
Hardware: PC Windows
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-09-21 16:08 UTC by Kimberle
Modified: 2019-10-14 19:57 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.