[Koha] DBMS auto increment

[Scott Owen]

Hi All,

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


Is this still the best procedure when getting the following error ?


************************************************

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 foundCheckouts

The following ids exist in both tables issues and old_issues:

4782, 4781


************************************************

Any sql to clean things up in the two tables ?