[Koha] Data problems "Check In"

Katrin Fischer katrin.fischer.83 at web.de
Sat Dec 15 01:08:34 NZDT 2018


What is your question? Have you checked the wiki page the text mentions? 
It explains all about the problem:

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

On 13.12.18 18:12, betocalderon wrote:
> The item has not been checked in due to a configuration issue in your system.
> You must ask an administrator to take a look at the about page and search
> for the "data problems" section.
>
> ***
> Data problems
>
> Some of your tables have problems with their auto_increment values which may
> lead to data loss.
>
> You should not ignore this warning.
>
> The problem is that InnoDB does not keep auto_increment across SQL server
> restarts (it is only set in memory). So on server startup the auto_increment
> values are set to max(table.id)+1.
>
> To know how to avoid this problem see the related wiki page: DBMS auto
> increment fix
> Problems found
> Items
>
> The following ids exist in both tables items and deleteditems:
>
> 7, 8, 9, 10
> Checkouts
>
> The following ids exist in both tables issues and old_issues:
>
> 1, 2, 3
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha


More information about the Koha mailing list