[Koha] DBMS auto increment issue - BUG19016

[Luis Moises Rojas]

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