[Koha] DBMS auto increment issue - BUG19016

[Jonathan Druart]

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.*
>
>