[Koha] Data problems

Rubeno Fernández enseikou at gmail.com
Fri Feb 9 03:14:27 NZDT 2018


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 at 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 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



More information about the Koha mailing list