The script on bug 19016 is supposed to deal with corrupted data correctly. At least for issues/old_issues (read comment 13 carefully!). However problems have been found for other tables, like items and biblio (see comments 16 and 17).
On Fri, 21 Sep 2018 at 12:42 Luis Moises Rojas <[email protected]> wrote: > Hello everybody, > > We all know this is destructive, meanwhile, which is the better soluction > in this case? > Thanks > > El jue., 20 de sep. de 2018 a la(s) 19:01, Jonathan Druart ( > [email protected]) escribió: > >> 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 <[email protected]> >> 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 <[email protected]> >>> 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 >>> > [email protected] >>> > https://lists.katipo.co.nz/mailman/listinfo/koha >>> > >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> [email protected] >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> > -- > *Luis Moisés Rojas P.* > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
