[Koha] Error returning a book

[Luis Moises Rojas]

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 <mishravk79 at gmail.com> 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 <
> lmoisesrojas at gmail.com> 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 <
>> libsitali at gmail.com> 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 <
>> libsitali at gmail.com>
>> > 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 <lmoisesrojas at gmail.com>
>> >> 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
>> >>> Koha at lists.katipo.co.nz
>> >>> 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
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>


-- 
*Luis Moisés Rojas P.*