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@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@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@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