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.
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.