[Koha] Duplicated ID in borrowers and deletedborrowers tables

Prof. Lisandro Laura prof.llaura at gmail.com
Tue Aug 22 13:14:14 NZST 2017


Thank you!
That fixed my issue...

2017-08-21 21:35 GMT-03:00 Joy Nelson <joy at 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 at 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 at 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?
>


More information about the Koha mailing list