Duplicated ID in borrowers and deletedborrowers tables
Hi everyone! I encountered an issue in the About Page: "The following ids exist in both borrowers y deletedborrowers tables: 52, 78" I think deleting the rows with "borrowernumber" equal to 52 and 78 in "deletedborrowers" table will fix this (in my case). What do you think about this action? How can I do it? Koha Version: 17.05.02.000 Debian 8.9 Thank you in advance, Lisandro
Lisandro- You will need direct access to the database to correct this. Login to mysql (or mariadb) and run the following query: delete from deletedborrowers where borrowernumber in (52,78); The above query will take care of those duplicated ids. joy On Mon, Aug 21, 2017 at 7:19 PM, Prof. Lisandro Laura <prof.llaura@gmail.com
wrote:
Hi everyone! I encountered an issue in the About Page: "The following ids exist in both borrowers y deletedborrowers tables: 52, 78"
I think deleting the rows with "borrowernumber" equal to 52 and 78 in "deletedborrowers" table will fix this (in my case). What do you think about this action? How can I do it?
Koha Version: 17.05.02.000 Debian 8.9
Thank you in advance, Lisandro _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Joy Nelson Director of Migrations ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>
Thank you! That fixed my issue... 2017-08-21 21:35 GMT-03:00 Joy Nelson <joy@bywatersolutions.com>:
Lisandro- You will need direct access to the database to correct this.
Login to mysql (or mariadb) and run the following query: delete from deletedborrowers where borrowernumber in (52,78);
The above query will take care of those duplicated ids.
joy
On Mon, Aug 21, 2017 at 7:19 PM, Prof. Lisandro Laura <prof.llaura@gmail.com> wrote:
Hi everyone! I encountered an issue in the About Page: "The following ids exist in both borrowers y deletedborrowers tables: 52, 78"
I think deleting the rows with "borrowernumber" equal to 52 and 78 in "deletedborrowers" table will fix this (in my case). What do you think about this action? How can I do it?
Koha Version: 17.05.02.000 Debian 8.9
Thank you in advance, Lisandro _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Joy Nelson Director of Migrations
ByWater Solutions Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha?
Yes it will fix the problem. On 22 Aug 2017 05:49, "Prof. Lisandro Laura" <prof.llaura@gmail.com> wrote:
Hi everyone! I encountered an issue in the About Page: "The following ids exist in both borrowers y deletedborrowers tables: 52, 78"
I think deleting the rows with "borrowernumber" equal to 52 and 78 in "deletedborrowers" table will fix this (in my case). What do you think about this action? How can I do it?
Koha Version: 17.05.02.000 Debian 8.9
Thank you in advance, Lisandro _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Fixed! Thank you... Lisandro 2017-08-22 2:43 GMT-03:00 vinod mishra <mishravk79@gmail.com>:
Yes it will fix the problem.
On 22 Aug 2017 05:49, "Prof. Lisandro Laura" <prof.llaura@gmail.com> wrote:
Hi everyone! I encountered an issue in the About Page: "The following ids exist in both borrowers y deletedborrowers tables: 52, 78"
I think deleting the rows with "borrowernumber" equal to 52 and 78 in "deletedborrowers" table will fix this (in my case). What do you think about this action? How can I do it?
Koha Version: 17.05.02.000 Debian 8.9
Thank you in advance, Lisandro _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Joy Nelson -
Prof. Lisandro Laura -
vinod mishra