[Koha] ids exist in both tables *borrowers* and *deletedborrowers*

[Katrin Fischer]

Hi Heinrich,

you can delete the "test" patron from deletedborrowers with SQL to
resolve the issue.

DELETE FROM deletedborrowers WHERE borrowernumber = 57;

The wiki page Alvaro linked to can then help to prevent the problem in
the future if your DBMS doesn't have the fix for the autoincrement bug yet:

https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix

Hope this helps,

Katrin

On 14.07.20 09:17, Heinrich Hartl wrote:
> From koha/about <System Information>
>
>
> Problems found
>
> Patrons
> The following ids exist in both tables *borrowers* and
> *deletedborrowers*:
> 57
>
>
> Yes, there is a borrowernr 57 in the table deletedborrowers with surname
> "test".
>
> And there is also a borrowernr. 57 in the table borrowers (this one is a
> real user of the library)
>
> What should I do to get rid of the deleted borrower 57?
>
> Regards
>
> Heinrich
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha