[Koha] help me auto increment issue to be fixed

takan bhatt takan.bhatt at gmail.com
Wed May 30 19:28:26 NZST 2018


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 <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>
Problems found Patrons

The following ids exist in both tables *borrowers* and *deletedborrowers*:

28


I am geting this warning.I have full koha backup. kindly help me. to
resolve this problem. I already fixed auto-incrementation bug.


Sincerely yours rajesh


I am using maria db


More information about the Koha mailing list