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
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________

Koha mailing list  http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to