Thank you! On Fri 13 Apr, 2018, 9:42 PM Chris Brown, <ch...@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.bh...@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 <indr...@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.bh...@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@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 >> > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha