Do you have the init-file trick setup correctly? https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Current_Solutio... Le jeu. 27 avr. 2023 à 10:06, Michael Kuhn <mik@adminkuhn.ch> a écrit :
Hi
We are working on Debian GNU/Linux 10 with MariaDB 10.3.38 and Koha 21.11.09.
Since about September 2022 after the update from Koha 18.11 to 21.11 we see auto_increment problems with tables "reserves" and "old_reserves" (but NOT with any of the other tables):
The following ids exist in both tables reserves and old_reserves:
372
In fact every single hold evokes the problem. Deleting the id manually from table "old_reserves" does always solve the problem:
DELETE FROM old_reserves WHERE reserve_id IN (372);
According to https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix the auto_increment problem should not occur at all after Koha 17.05.
What could be the reason for this behavior?
Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha