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

[vinod mishra]

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,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
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
Gandhi*

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

> Hi,
>
> I am running Koha 17.05.05.000 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
>