[Koha] check in error: koha 19.05

[Alvaro Cornejo]

Hi

As stated in the error, you must follow instructions on the mentioned link

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

If you do not apply the fix, you risk having duplicate records after mysql
restarts. Note that error already reported some duplicates.

Regards

Alvaro

|----------------------------------------------------------------------------------------|
 Stay safe / Cuídate/  Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le ven. 19 mars 2021 à 02:09, Yatheesh lis <yatheeshb at gmail.com> a écrit :

> Hi
>
> when i am doing check in I am getting the following error  can any one
> suggest solution
>
> 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 <
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>
> Problems foundPatrons
>
> The following ids exist in both tables borrowers and deletedborrowers:
>
> 53
> Bibliographic records
>
> The following ids exist in both tables biblio and deletedbiblio:
>
> 3288
> Checkouts
>
> The following ids exist in both tables issues and old_issues:
>
> 1
>
> --
>
> Y.Yatheesh Babu
> 8247838231
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>