[Koha] Data problems

[Jonathan Druart]

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.tgs at 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 <johan at 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.tgs at 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 at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>