[Koha] unable to check-in

[takan bhatt]

I have no such sanction in my.cnf

This is instructed in
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
Locate the [mysqld] section and add:

On Fri, Apr 13, 2018 at 5:15 AM, Indranil Das Gupta <indradg at gmail.com>
wrote:

> Hi,
>
> Explicit instructions are already given in the error message itself (which
> you have pasted here)
>
> Pls follow them to fix your system.
>
> Regards
> Indranil Das Gupta
> L2C2 Technologies.
>
>
>
> On Fri 13 Apr, 2018, 2:41 PM takan bhatt, <takan.bhatt at gmail.com> wrote:
>
>> I am getting this msg while check in  Check in message
>>
>> 05138: Strategic brand management :
>> <http://192.168.1.109:8080/cgi-bin/koha/catalogue/detail.
>> pl?type=intra&biblionumber=1>
>>
>> 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://192.168.1.109:8080/cgi-bin/koha/about.pl#sysinfo> and search for
>> the "data problems" section
>>
>>
>> About Koha
>>
>>    - Server information
>>    <http://192.168.1.109:8080/cgi-bin/koha/about.pl#about>
>>    - Perl modules <http://192.168.1.109:8080/cgi-bin/koha/about.pl#perl>
>>    - System information
>>    <http://192.168.1.109:8080/cgi-bin/koha/about.pl#sysinfo>
>>    - Koha team <http://192.168.1.109:8080/cgi-bin/koha/about.pl#team>
>>    - Licenses <http://192.168.1.109:8080/cgi-bin/koha/about.pl#licenses>
>>    - Translations
>>    <http://192.168.1.109:8080/cgi-bin/koha/about.pl#translations>
>>    - Timeline <http://192.168.1.109:8080/cgi-bin/koha/about.pl#history>
>>
>> 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 foundCheckouts
>>
>> The following ids exist in both tables *issues* and *old_issues*:
>>
>> 1
>>
>> Warnings regarding the system configurationPreferences 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.
>>
>> Server information
>> Koha version: 17.11.04.000
>> OS version ('uname -a'): Linux debian 4.9.0-4-amd64 #1 SMP Debian
>> 4.9.65-3+deb9u1 (2017-12-23) x86_64
>> Perl interpreter: /usr/bin/perl
>> Perl version: 5.024001
>> Perl @INC: /usr/share/koha/lib
>> /etc/perl
>> /usr/local/lib/x86_64-linux-gnu/perl/5.24.1
>> /usr/local/share/perl/5.24.1
>> /usr/lib/x86_64-linux-gnu/perl5/5.24
>> /usr/share/perl5
>> /usr/lib/x86_64-linux-gnu/perl/5.24
>> /usr/share/perl/5.24
>> /usr/local/lib/site_perl
>> /usr/lib/x86_64-linux-gnu/perl-base
>> MySQL version: mysql Ver 15.1 Distrib 10.1.26-MariaDB, for
>> debian-linux-gnu
>> (x86_64) using readline 5.2
>> Apache version: Server version: Apache/2.4.25 (Debian)
>> Memcached: Servers: undefined | Namespace: undefined | Status: unknown |
>> Config read from: Nowhere Note that the right place to define the
>> memcached
>> config is in your $KOHA_CONF file. Currently you do not have a valid
>> memcached configuration defined. | Effective caching method: Cache::Memory
>> Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free
>> software, covered by the GNU General Public License, and you are welcome
>> to
>> change it and/or distribute copies of it under certain conditions. SHA1
>> ID:
>> c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU
>>
>> Kindly help me to overcome this problem
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>