[Koha] DBMS auto increment issue - BUG19016

[Jonathan Druart]

Important note: This is a destructive method, you are going to lose
circulation data!

Please do not forget to mention it when you suggest people to remove rows
from their tables :)

On Thu, 20 Sep 2018 at 19:39 Luis Moises Rojas <lmoisesrojas at gmail.com>
wrote:

> 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
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>