[Koha] unable to check-in

[takan bhatt]

Thank you!

On Fri 13 Apr, 2018, 9:42 PM Chris Brown, <chris at stayawake.co.uk> wrote:

> Hi Takan,
>
> It's OK to add your own [mysqld] section in the file if there isn't one
> there already. I think it just says that this part of the file only relates
> to the mysql server, not the client.
>
> Hope this helps,
>
> Chris Brown
>
>
> On Fri, Apr 13, 2018 at 10:37 AM, takan bhatt <takan.bhatt at gmail.com>
> wrote:
>
>> 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
>> >>
>> >
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>