http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523 Isabela Terra <isabelaterra@cp2.g12.br> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |RESOLVED Resolution|--- |FIXED --- Comment #6 from Isabela Terra <isabelaterra@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.