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.
See the related wiki page <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix> to know how to avoid this problem. Problems foundUsuarios The following ids exist in both *borrowers* y *deletedborrowers* tables: 167, 168, 220, 786 Registros: The following ids exist in both *biblio* y *deletedbiblio* tables: 10950, 10951, 10952, 10953, 10954, 10955, 10956, 10957, 10958, 10959, 10960, 10961, 10962, 10963, 10964, 10965, 10966, 10968, 10969, 10970, 10971, 10972, 10973, 10974, 10975, 10976, 10978, 10979..... Ítems The following ids exist in both *items* y *deleteditems* tables: 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1146, 1147, 1148, 1151, 1152, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1163, 1164, 1165, 1166, 1167, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1183, 1187, 1188, 1192, 1196, 1200, 1201, 1203, 1204, 1205, 1208, 1209, 1212, 1213, 1214, 1217, 1219, 1220, 1221, 11421, Préstamos The following ids exist in both *issues* y *old_issues* tables: 335, 427, 423, 39, 425, 46, 438, 415, 401, 3, 405, 338, 61, 408, 426, 377, 436, 444, 383, 291, 352, 374, 411, 376, 368, 369, 402, 409, 435, 49, 378, 417, 357, 372, 407, 433, 62, 445, 439, 403, 388, 292, 360, 446, 406, 414, 434, 363, 428, 448, 221, 429, 294, 382, 430, 432, 361, 100, 410, 47, 412, 295, 41, 40, 421, 379, 273, 45.... On Tue, Aug 22, 2017 at 2:32 PM, vinod mishra <[email protected]> wrote: > Is it still showing any number in about page? if so than you may delete it > and try again. > > > With Regards, > > Vinod Kumar Mishra, > Assistant Librarian, > Biju Patnaik Central Library (BPCL), > NIT Rourkela, > Sundergadh-769008, > Odisha, > India. > Mob:91+9439420860 > Website: http://mishravk.com/ > ORCID ID: http://orcid.org/0000-0003-4666-7874 > > *"Spiritual relationship is far more precious than physical. Physical > relationship divorced from spiritual is body without soul" -- Mahatma > Gandhi* > > On Tue, Aug 22, 2017 at 11:49 PM, Luis Moises Rojas < > [email protected]> wrote: > >> First, thanks to all of you. >> >> We have done everything >> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix says: >> >> But will still have the error: >> The message is The item has not been checked in due to a configuration >> issue in your system. You must ask an administrator to take a look at the >> about page and search for the "data problems" section" >> >> On Tue, Aug 22, 2017 at 12:05 PM, Chrispin Simasiku Sitali < >> [email protected]> wrote: >> >> > Furthermore, thanks to Joy Nelson, use the following; >> > You will need direct access to the database to correct this. >> > >> > Login to mysql (or mariadb) and run the following query: >> > delete from deletedborrowers where borrowernumber in (52,78); >> > >> > The above query will take care of those duplicated ids. >> > >> > Also thanks to Jonathan Druart look at; >> > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix >> > >> > Cheers >> > >> > Sitali CS >> > >> > On 22 August 2017 at 18:00, Chrispin Simasiku Sitali < >> [email protected]> >> > wrote: >> > >> >> Its because of duplicate ids in your database. Please log in as >> >> administrator (Staff Client of course) and go to About Koha. You will >> find >> >> a list of errors. Those duplicate ids need to be deleted >> >> >> >> Sitali CS >> >> >> >> On 22 August 2017 at 17:49, Luis Moises Rojas <[email protected]> >> >> wrote: >> >> >> >>> Hello everybody, >> >>> >> >>> We are having this problem when we try to return a borrowed book: >> >>> >> >>> "The item has not been checked in due to a configuration issue in >> >>> your system." >> >>> >> >>> What this mean? >> >>> >> >>> Thanks >> >>> >> >>> -- >> >>> *Luis Moisés Rojas P.* >> >>> >> >>> >> >>> <https://www.avast.com/sig-email?utm_medium=email&utm_source >> >>> =link&utm_campaign=sig-email&utm_content=webmail> >> >>> Libre >> >>> de virus. www.avast.com >> >>> <https://www.avast.com/sig-email?utm_medium=email&utm_source >> >>> =link&utm_campaign=sig-email&utm_content=webmail> >> >>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> >> >>> _______________________________________________ >> >>> Koha mailing list http://koha-community.org >> >>> [email protected] >> >>> https://lists.katipo.co.nz/mailman/listinfo/koha >> >>> >> >> >> >> >> >> >> >> -- >> >> Charles Lwanga College of Education, >> >> P. O. Box 660193, >> >> Monze, >> >> ZAMBIA. >> >> >> >> Mobile: +26 0979 869471 >> >> +26 0966 869471 >> >> SKYPE: Libsitali >> >> >> > >> > >> > >> > -- >> > Charles Lwanga College of Education, >> > P. O. Box 660193, >> > Monze, >> > ZAMBIA. >> > >> > Mobile: +26 0979 869471 >> > +26 0966 869471 >> > SKYPE: Libsitali >> > >> >> >> >> -- >> *Luis Moisés Rojas P.* >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > -- *Luis Moisés Rojas P.* _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
