[Koha-bugs] [Bug 13523] AddBiblio fails on mysql with STRICT_TRANS_TABLES

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523

Isabela Terra <isabelaterra at cp2.g12.br> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |isabelaterra at cp2.g12.br
             Status|Needs Signoff               |Failed QA

--- Comment #5 from Isabela Terra <isabelaterra at cp2.g12.br> ---
(In reply to Benjamin Rokseth from comment #4)
> Created attachment 35456 [details] [review]
> Bug 13523 - AddBiblio fails on mysql with STRICT_TRANS_TABLES
> 
> This patch removes the NOT NULL restriction on biblioitems.marcxml and
> deletedbiblioitems.marcxml due to STRICT_TRANS_TABLES default in
> Mysql 5.6.22 and onwards.
> 
> Test:
> 
> 1. check mysql global settings:
>    mysql > SELECT @@GLOBAL.sql_mode;
>    verify that STRICT_TRANS_TABLES is not set
> 2. set STRICT_TRANS_TABLES (or upgrade mysql to > 5.6.21)
>    mysql > SET @@GLOBAL.sql_mode = 'STRICT_TRANS_TABLES';
> 3. try to add biblio in Cataloguing module
>    verify that it fails with a "software error"
> 4. apply patch
> 5. repeat 3 and verify that there is no "software error" any more

Hello,
I applied these changes but the error continues.
Is there anything else for me to do?

-- 
You are receiving this mail because:
You are watching all bug changes.