Hello, Thank you so much for your email. I am very scared about the data loss. So I didn't fix the problem. Can you please help me step by step? Thank you so much.
On Wed, Feb 7, 2018 at 11:26 PM, Johan Seyfferdt <[email protected]> wrote: > Hi. Have you fixed your problem yet? I had a similar situation a few weeks > ago and I am willing to help if you still need it. > > Johan > > On Feb 5, 2018 14:37, "Ashok Francis" <[email protected]> wrote: > > Dear All, > > I am using Koha 17.11.02 version. When I visit the page About Koha --- > system information---, I am getting the information like data problem. Can > anyone please help me how to solve this problem? > > 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_fi > x> > Problems foundPatrons > > The following ids exist in both tables *borrowers* and *deletedborrowers*: > > 1322 > Items > > The following ids exist in both tables *items* and *deleteditems*: > > 15979, 15980, 20761, 21245 > Holds > > The following ids exist in both tables *holds* and *old_reserves*: > > 2, 3, 1 > > I will be thankful to you. > > Ashok. > New Delhi. > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
