Pedro, Please answer to the list. Yes it's the easy and lazy solution. If you want to use MySQL 5.6, you must disable STRICT_TRANS_TABLES, otherwise you will encounter some errors. But we should take care of these errors and fix them.
Regards, Jonathan 2015-10-29 16:51 GMT+00:00 Pedro Amorim <pjamori...@gmail.com>: > Hello Jonathan, > > Thank you for your reply. > > I have removed STRICT_TRANS_TABLES in both usr/my.cnf and etc/mysql/my.cnf > and solved the following detected bugs: > 1) Z39.50 import_records table insertion; > 2) Z30.50 server creation with empty values on timeout and order; > 3) Creating new category for patron -> Category already exists. > > And ( I imagine ) countless others. > > Let me know what you think about this, please. > > Thank you, > > Pedro Amorim > > > > 2015-10-29 7:20 GMT-01:00 Jonathan Druart > <jonathan.dru...@bugs.koha-community.org>: >> >> See all bug 13526 and the discussion on bug 5366 >> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523 >> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5366 >> >> 2015-10-29 8:16 GMT+00:00 Jonathan Druart >> <jonathan.dru...@bugs.koha-community.org>: >> > Hello Pedro, >> > >> > You should not use MySQL 5.6, some bugs are known: bug 13669 and bug >> > 14637, and certainly some others. >> > Until now nobody has shown a special interest for these issues. >> > >> > Regards, >> > Jonathan >> > >> > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 >> > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637 >> > >> > 2015-10-28 16:17 GMT+00:00 Pedro Amorim <pjamori...@gmail.com>: >> >> Also, some other thing to note: >> >> >> >> The mysql I'm running is 5.6.25. >> >> >> >> 2015-10-28 15:14 GMT-01:00 Pedro Amorim <pjamori...@gmail.com>: >> >> >> >>> Hello, >> >>> >> >>> Version: Koha 3.2002000 >> >>> >> >>> My name is Pedro Amorim and I've been implementing Koha for the first >> >>> time >> >>> for the past couple of days now. >> >>> >> >>> This is a fresh package install. >> >>> >> >>> This is a bug (I think) I stumbled upon and this is how I solved it: >> >>> When performing a Z39.50 search I kept getting no records found >> >>> despite >> >>> the fact that I knew there were records (doing a yaz-client search and >> >>> using the online demo returned results, so why didn't it return in my >> >>> installation?). >> >>> >> >>> So I found out that the records should've been inserted in the >> >>> import_records table but they weren't. Because marcxml_old wasn't >> >>> being >> >>> defined and it expected some value (NULL = NO), so I went in and >> >>> changed >> >>> the database structure to NULL = YES and everything is now working as >> >>> expected. >> >>> >> >>> I think this also has something to do with mysql STRICT_TRANS_TABLES >> >>> but I >> >>> would like some confirmation on that. >> >>> >> >>> I'm new in the whole Koha scene and don't yet know how to submit bugs. >> >>> I'm sending this mail in the hopes that someone confirms that this is >> >>> indeed a bug and document the given solution. >> >>> >> >>> Cheers >> >>> >> >> _______________________________________________ >> >> 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