Koha Check- Error -The item has not been checked in due to a configuration issue in your system.
Hi I have upgraded my Koha to version . Now when I check in an item I am getting the following error: 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://uzlibraries.uz.ac.zw:8080/cgi-bin/koha/about.pl#sysinfo> and search for the "data problems" section. When I visit the About page, I am greeted with : 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 found Checkouts The following ids exist in both issues and old_issues tables: 2, 3 Warnings regarding the system configuration However, when I check the schema for old_issues, it has no auto-increment turn on for issue_id though it is the primary key I will appreciate any pointers Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263771117777 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>
Hello Admire, Indeed there is no auto increment field on old_issues, but it is not where the problem comes from. You have issues.issue_id with 2 and 3. But these 2 values already exist in the old_issues table. When the checkin is done, the row is moved from one table to the other, but old_issues.issue_id is a primary key and the move will fail. Please read again the wiki page, I have added some more information today. We are going to provide a way to deal with your corrupted data soon. Regards, Jonathan On Mon, 31 Jul 2017 at 07:17 Admire Mutsikiwa <amutsikiwa@uzlib.uz.ac.zw> wrote:
Hi
I have upgraded my Koha to version . Now when I check in an item I am getting the following error:
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://uzlibraries.uz.ac.zw:8080/cgi-bin/koha/about.pl#sysinfo
and search for the "data problems" section.
When I visit the About page, I am greeted with :
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 found
Checkouts
The following ids exist in both issues and old_issues tables: 2, 3
Warnings regarding the system configuration
However, when I check the schema for old_issues, it has no auto-increment turn on for issue_id though it is the primary key
I will appreciate any pointers
Kind Regards,
Admire Mutsikiwa (Mr)
ICT Manager
Libraries
University of Zimbabwe
Tel:+263-4-303276 <+263%204%20303%20276>
Mob:+263771117777 <+263%2077%20111%207777>
"It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Admire Mutsikiwa -
Jonathan Druart