[Koha] DBMS auto increment issue

[Katrin Fischer]

Hi Daniel,

deleting the lines from the deleted* and old* tables is usually the
easiest way to fix this issue. Can you share your error message and your
SQL you used in phpmyadmin? Maybe we can spot where the issue is.

Katrin

On 21.09.20 06:34, Daniel Owens wrote:
> I am running Koha 20.05.02.000.
>
> I have corrupted data due to the DBMS auto increment issue.
>
> How can I deal with corrupted data? I tried following the advice to
> remove the affected lines from deleted* tables, but in the two items I
> checked, I could not find those ids. To find the ids listed in the
> About Koha - System Information message, I searched in the affected
> tables (deletedbiblios and deleteditems) using phpmyadmin.
>
> So I am confused about how to deal with the corrupted data. Can anyone
> suggest a way forward for me?
>
> Daniel
>
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha