[Koha-bugs] [Bug 13523] AddBiblio fails on mysql with STRICT_TRANS_TABLES
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Jan 29 14:34:13 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523
Isabela Terra <isabelaterra at cp2.g12.br> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|Failed QA |RESOLVED
Resolution|--- |FIXED
--- Comment #6 from Isabela Terra <isabelaterra at cp2.g12.br> ---
(In reply to Isabela Terra from comment #5)
> (In reply to Benjamin Rokseth from comment #4)
> > Created attachment 35456 [details] [review] [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?
Resolved! Thanks!
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list