Re: [Koha] DBMS auto increment issue - BUG19016

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 (<

Re: [Koha] DBMS auto increment issue - BUG19016

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 wrote: >

Re: [Koha] DBMS auto increment issue - BUG19016

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 >

Re: [Koha] DBMS auto increment issue - BUG19016

Yes, that is correct El jue., 20 de sept. de 2018 7:01 PM, 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

Re: [Koha] DBMS auto increment issue - BUG19016

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 wrote: > Hi, > I still do not know why this happen and when they

Re: [Koha] DBMS auto increment issue - BUG19016

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

Re: [Koha] DBMS auto increment issue - BUG19016

Hi Sven After creating the init scripts as per the links you show, you need to manually remove the records -accessing mysql directly- shown in the about page. You just need to remove them from one of the tables. Regards, Alvaro

[Koha] DBMS auto increment issue - BUG19016

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