Discussion:
[Koha] DBMS auto increment issue - BUG19016
Sven Halm
2018-09-20 20:04:15 UTC
Permalink
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 ]
Alvaro Cornejo
2018-09-20 21:54:57 UTC
Permalink
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

|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
Visitenos en www.perusms.com
Post by Sven Halm
Hi all,
i have got the BUG19016 (https://bugs.koha-community.
org/bugzilla3/show_bug.cgi?id=19016) problem in my production
---start quote---
Problems found
Items
1016, 1017 Checkouts
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
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo
Luis Moises Rojas
2018-09-20 22:39:23 UTC
Permalink
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
Post by Sven Halm
Hi all,
i have got the BUG19016 (
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016) problem
---start quote---
Problems found
Items
1016, 1017 Checkouts
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
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.katipo.
Luis Moises Rojas
2018-09-21 00:03:51 UTC
Permalink
Yes, that is correct

El jue., 20 de sept. de 2018 7:01 PM, Jonathan Druart <
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 :)
Post by Luis Moises Rojas
Hi,
I still do not know why this happen and when they going to fix it.
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
Post by Sven Halm
Hi all,
i have got the BUG19016 (
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016)
problem
Post by Sven Halm
---start quote---
Problems found
Items
1016, 1017 Checkouts
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
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://list
Luis Moises Rojas
2018-09-21 15:42:20 UTC
Permalink
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 (
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 :)
Post by Luis Moises Rojas
Hi,
I still do not know why this happen and when they going to fix it.
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
Post by Sven Halm
Hi all,
i have got the BUG19016 (
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016)
problem
Post by Sven Halm
---start quote---
Problems found
Items
1016, 1017 Checkouts
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
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha
--
*Luis Moisés Rojas P.*
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
Tomas Cohen Arazi
2018-09-21 18:29:08 UTC
Permalink
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 (<
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).
Post by 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 (
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
Post by Luis Moises Rojas
from their tables :)
Post by Luis Moises Rojas
Hi,
I still do not know why this happen and when they going to fix it.
Go to old_issues and delete those itemnumber. You can use the
phpmyadmin
Post by Luis Moises Rojas
Post by Luis Moises Rojas
or
use the console
Delete from old_issues where itemnumber=here goes your number
Post by Sven Halm
Hi all,
i have got the BUG19016 (
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016)
problem
Post by Sven Halm
---start quote---
Problems found
Items
1016, 1017 Checkouts
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
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha
--
*Luis Moisés Rojas P.*
_______________________________________________
Koha mailing list http://koha-community.org
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
***@lists.katipo.co.nz
https://lists.katipo.co
Loading...