The only issue I see is action_logs will contain invalid references if used as_is. The date the object (conflicting) was created should be used to know how to upgradethe action_logs and statistics entries.
El vie., 21 sept. 2018 a las 13:14, Jonathan Druart (< jonathan.dru...@bugs.koha-community.org>) escribió: > 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 <lmoisesro...@gmail.com> > 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 ( > > jonathan.dru...@bugs.koha-community.org) 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 <lmoisesro...@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.h...@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@lists.katipo.co.nz > >>> > https://lists.katipo.co.nz/mailman/listinfo/koha > >>> > > >>> _______________________________________________ > >>> Koha mailing list http://koha-community.org > >>> Koha@lists.katipo.co.nz > >>> https://lists.katipo.co.nz/mailman/listinfo/koha > >>> > >> > > -- > > *Luis Moisés Rojas P.* > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha