There is a "Deal with corrupted data" section on the wiki which point to a bug report, with a proposed patch. You can try it and see if it works for you. Good luck
On Sat, 10 Feb 2018 at 02:24 Ashok Francis <ashokfrancis....@gmail.com> wrote: > 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 <jo...@spbcu.ru> 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" <ashokfrancis....@gmail.com> > 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 > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha