ids exist in both tables *borrowers* and *deletedborrowers*
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
Hi Heinrich, You may be running into this issue: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix On Tue, Jul 14, 2020 at 3:18 AM Heinrich Hartl <h-hartl@gmx.de> 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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Heinrich Hartl -
Katrin Fischer -
rogan.hamby@gmail.com