[Koha] DBMS_auto_increment : cannot check-in items checked out before a certain upgrade

Giuseppe Angilella Giuseppe.Angilella at ct.infn.it
Sun Oct 29 17:37:35 NZDT 2017


I am running Koha on Ubuntu 14.04.1 with mysql Ver 14.14 Distrib 

I regularly upgrade Koha via apt-get, and I've suddenly realized I cannot 
check-in items which had been checked-out (presumably before a certain 

I can check-in items which have been checked-out with the presently installed 
release of Koha.

Following the error message, I came across the wiki page:


I followed the instructions given there, and added the additional init file as 
described there. No error reported by /var/log/mysql/error.log upon restarting 
or running the mysql service.

However, I cannot yet check-in back items which were checked-out in the past. 
(I can still do that with new check-outs.)

Since it seems that the problem is solved with new check-outs, would you 
recommend that I manually remove old check-outs from the database, and issue 
them again (with a new date - doesn't matter, as long as it works)?

Many thanks and best regards,


More information about the Koha mailing list