subject:"\[Koha\] Error returning a book"

Re: [Koha] Error returning a book

2017-08-22 Thread 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
 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  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/-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 <
> lmoisesro...@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 <
>> libsit...@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 <
>> libsit...@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 
>> >> 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.*
>> >>>
>> >>>
>> >>> > >>> =link_campaign=sig-email_content=webmail>
>> >>> Libre
>> >>> de virus. www.avast.com
>> >>> > >>> =link_campaign=sig-email_content=webmail>
>> >>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>> >>> ___
>> >>> Koha mailing list  http://koha-community.org
>> >>> Koha@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

Re: [Koha] Error returning a book

2017-08-22 Thread vinod mishra

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/-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 
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 <
> libsit...@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 <
> libsit...@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 
> >> 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.*
> >>>
> >>>
> >>>  >>> =link_campaign=sig-email_content=webmail>
> >>> Libre
> >>> de virus. www.avast.com
> >>>  >>> =link_campaign=sig-email_content=webmail>
> >>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> >>> ___
> >>> Koha mailing list  http://koha-community.org
> >>> Koha@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@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

Re: [Koha] Error returning a book

2017-08-22 Thread Luis Moises Rojas

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 <
libsit...@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 
> 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 
>> 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.*
>>>
>>>
>>> >> =link_campaign=sig-email_content=webmail>
>>> Libre
>>> de virus. www.avast.com
>>> >> =link_campaign=sig-email_content=webmail>
>>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@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@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error returning a book

2017-08-22 Thread Chrispin Simasiku Sitali

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 
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 
> 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.*
>>
>>
>> > =link_campaign=sig-email_content=webmail>
>> Libre
>> de virus. www.avast.com
>> > =link_campaign=sig-email_content=webmail>
>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error returning a book

2017-08-22 Thread Luis Moises Rojas

Is this error the same:
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.

On Tue, Aug 22, 2017 at 12:03 PM, Luis Moises Rojas 
wrote:

> Hi Chrispin:
> Do we have to deleted manually?
>
>
> 
>  Libre
> de virus. www.avast.com
> 
> <#m_-7358004622330201757_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> On Tue, Aug 22, 2017 at 12:00 PM, Chrispin Simasiku Sitali <
> libsit...@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 
>> 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.*
>>>
>>>
>>> >> =link_campaign=sig-email_content=webmail>
>>> Libre
>>> de virus. www.avast.com
>>> >> =link_campaign=sig-email_content=webmail>
>>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@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
>>
>
>
>
> --
> *Luis Moisés Rojas P.*
>
>


-- 
*Luis Moisés Rojas P.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error returning a book

2017-08-22 Thread Luis Moises Rojas

Hi Chrispin:
Do we have to deleted manually?


Libre
de virus. www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, Aug 22, 2017 at 12:00 PM, Chrispin Simasiku Sitali <
libsit...@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 
> 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.*
>>
>>
>> > =link_campaign=sig-email_content=webmail>
>> Libre
>> de virus. www.avast.com
>> > =link_campaign=sig-email_content=webmail>
>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@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
>



-- 
*Luis Moisés Rojas P.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error returning a book

2017-08-22 Thread Chrispin Simasiku Sitali

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 
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.*
>
>
>  source=link_campaign=sig-email_content=webmail>
> Libre
> de virus. www.avast.com
>  source=link_campaign=sig-email_content=webmail>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> ___
> Koha mailing list  http://koha-community.org
> Koha@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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error returning a book

Re: [Koha] Error returning a book

Re: [Koha] Error returning a book

Re: [Koha] Error returning a book

Re: [Koha] Error returning a book

Re: [Koha] Error returning a book

Re: [Koha] Error returning a book

7 matches

Site Navigation

Mail list logo

Footer information