[Koha] Z39.50 Bug -> marcxml_old on import_records table

[Jonathan Druart]

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 at 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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha