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 <[email protected]> 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, <[email protected]> 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 >> [email protected] >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
