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 ]
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 2018-09-20 15:04 GMT-05:00 Sven Halm <sven.halm@shalm.de>:
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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Yes, that is correct El jue., 20 de sept. de 2018 7:01 PM, Jonathan Druart < jonathan.druart@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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Luis Moisés Rojas P.*
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@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@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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Luis Moisés Rojas P.*
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@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@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@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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@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@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
participants (5)
-
Alvaro Cornejo -
Jonathan Druart -
Luis Moises Rojas -
Sven Halm -
Tomas Cohen Arazi