CHECK IN ERROR

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

CHECK IN ERROR

murphy
*Hi everyone,*

*I am using koha version 17.11 with the database Mysql ver15.11
distribution 10.0.36-MariaDB.  I want to "**check in" and the error message
below appears, I click on about page and the second information about data
problems comes out. Please what can I do. I have limited knowledge with
mysql and MariaDB.*

*Thanks a lot.*


*Check in error message message*

037655: Computer Science
<http://154.68.225.19:8001/cgi-bin/koha/catalogue/detail.pl?type=intra&biblionumber=136>

*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
<http://154.68.225.19:8001/cgi-bin/koha/about.pl#sysinfo> and search for
the "data problems" section*

Top of Form


About page information 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 found Patrons

The following ids exist in both tables *borrowers* and *deletedborrowers*:

4
Checkouts

The following ids exist in both tables *issues* and *old_issues*:

16, 17, 18



Warnings regarding the system configuration

*Preferences and parameters*

*Warning*

You are missing the <template_cache_dir> entry in your koha-conf.xml file.
That will bring a performance boost to enable it.
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: CHECK IN ERROR

Jonathan Druart
Hello Igbudu,

Did you read the wiki page? Which part(s) need clarification?

Regards,
Jonathan

On Mon, 8 Oct 2018 at 09:03 Igbudu Tersoo <[hidden email]> wrote:

> *Hi everyone,*
>
> *I am using koha version 17.11 with the database Mysql ver15.11
> distribution 10.0.36-MariaDB.  I want to "**check in" and the error message
> below appears, I click on about page and the second information about data
> problems comes out. Please what can I do. I have limited knowledge with
> mysql and MariaDB.*
>
> *Thanks a lot.*
>
>
> *Check in error message message*
>
> 037655: Computer Science
> <
> http://154.68.225.19:8001/cgi-bin/koha/catalogue/detail.pl?type=intra&biblionumber=136
> >
>
> *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
> <http://154.68.225.19:8001/cgi-bin/koha/about.pl#sysinfo> and search for
> the "data problems" section*
>
> Top of Form
>
>
> About page information 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 found Patrons
>
> The following ids exist in both tables *borrowers* and *deletedborrowers*:
>
> 4
> Checkouts
>
> The following ids exist in both tables *issues* and *old_issues*:
>
> 16, 17, 18
>
>
>
> Warnings regarding the system configuration
>
> *Preferences and parameters*
>
> *Warning*
>
> You are missing the <template_cache_dir> entry in your koha-conf.xml file.
> That will bring a performance boost to enable it.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha