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 <amutsik...@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 > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha