Re: [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 :
> 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
> :
>>
>> 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
>> :
>> > 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 :
>> >> 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 :
>> >>
>> >>> 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

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

[Jonathan Druart]

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
:
> 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 :
>> 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 :
>>
>>> 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

Re: [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 :
> 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 :
>
>> 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] Z39.50 Bug -> marcxml_old on import_records table

[Pedro Amorim]

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

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

[Pedro Amorim]

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 :

> 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