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@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_fix> 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
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@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@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
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@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@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@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
participants (3)
-
Ashok Francis -
Johan Seyfferdt -
Jonathan Druart