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

---

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha