[Koha] Duplicated ID in borrowers and deletedborrowers tables
Prof. Lisandro Laura
prof.llaura at gmail.com
Tue Aug 22 13:14:14 NZST 2017
That fixed my issue...
2017-08-21 21:35 GMT-03:00 Joy Nelson <joy at bywatersolutions.com>:
> 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.
> 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,
>> Koha mailing list http://koha-community.org
>> Koha at lists.katipo.co.nz
> 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