[Koha] DBMS auto increment issue - BUG19016

Tomas Cohen Arazi tomascohen at gmail.com
Sat Sep 22 06:29:08 NZST 2018


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.druart at 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 <lmoisesrojas at 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.druart at 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 <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
> >>>
> >>
> > --
> > *Luis Moisés Rojas P.*
> >
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at 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


More information about the Koha mailing list