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.druart@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 <pjamorim91@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 <pjamorim91@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