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

[Jonathan Druart]

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 at 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 at 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 at 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 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
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>