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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha