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

vinod mishra mishravk79 at gmail.com
Tue Oct 31 17:19:23 NZDT 2017

You see the "About Koha>system information" page and remove all duplicate
key/record from oldissues table etc. if it displayed you some error

With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Website: http://mishravk.com/
ORCID ID: http://orcid.org/0000-0003-4666-7874

*"Spiritual relationship is far more precious than physical. Physical
relationship divorced from spiritual is body without soul" -- Mahatma

On Sun, Oct 29, 2017 at 10:07 AM, Giuseppe Angilella <
Giuseppe.Angilella at ct.infn.it> wrote:

> Hi,
> I am running Koha on Ubuntu 14.04.1 with mysql Ver 14.14
> Distrib 5.5.58.
> 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
> upgrade).
> 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:
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
> 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,
> Giuseppe.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list