[Koha] Koha Check- Error -The item has not been checked in due to a configuration issue in your system.

[Jonathan Druart]

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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>