Hello, I had this problem and I did apply the solution on this page: <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix> However, even after rebooting the server I see the same warning on the About Koha: System information page. Why? Is this the expected behaviour? Rubeno El dilluns, 5 de febrer de 2018, a les 15:33:39 CET, Alvaro Cornejo va escriure:
Hi
You should follow apply the fix mentioned on the link.
About the duplicated entries, you should access tables "deletedborrowers", "deleteditems" and "old_reserves" and delete entries that have the mentioned indexes. Note that you will loose the info of those records.
Regards,
Alvaro
|--------------------------------------------------------------------------- |--------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com
2018-02-05 6:36 GMT-05:00 Ashok Francis <ashokfrancis.tgs@gmail.com>:
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
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha