[Koha] unable to check-in

[Chris Brown]

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
>