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

[Pedro Amorim]

Hello Giuseppe,

Yes. I recently came across this and you can check my post here:
http://koha.1045719.n5.nabble.com/Salvaging-data-before-using-DBMS-auto-increment-fix-td5951803.html

Have a good one,

Pedro Amorim

On 29 October 2017 at 03:37, 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
>