[Koha] DBMS auto increment issue - BUG19016

[Luis Moises Rojas]

Hi,
I still do not know why this happen and when they going to fix it.
I have several solutions which i am going to submit , but here is:

Go to old_issues and delete those itemnumber. You can use the phpmyadmin or
use the console

Delete from old_issues where itemnumber=here goes your number

El jue., 20 de sept. de 2018 4:05 PM, Sven Halm <sven.halm at shalm.de>
escribió:

> Hi all,
>
> i have got the BUG19016 (
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016) problem
> in my production environment. The koha system information says:
>
> ---start quote---
> Problems found
> Items
>
>
> The following ids exist in both tables items and deleteditems :
>
> 1016, 1017 Checkouts
>
>
> The following ids exist in both tables issues and old_issues :
>
> 587, 590, 589, 586, 584, 585, 588, 583, 582
> ---end quote---
>
> After i had read the artikels i implemented the init script (see [
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix |
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix ] ).
>
> But how can i resolve the problem? I don't know how to do that.
>
> Could you help, please?
>
> Kind regards
> Sven
>
> library: [ https://lesehoehle.foerderverein-hellwegschule.de/ |
> https://lesehoehle.foerderverein-hellwegschule.de ]
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>