https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #50 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Bernardo Gonzalez Kriegel from comment #49)
Errors are not in the procedeure, I tested extensively but on msyql < 5.6, so this is specific to ver 5.6+ treatment of SQL, or 5.7 more specifically
1) table: auth_subfield_structure
line: 72 `defaultvalue` TEXT DEFAULT '', error: (BLOB, TEXT, GEOMETRY or JSON column 'defaultvalue' can't have a default value): CREATE TABLE `auth_subfield_structure`
Seems that we can't have default values here.
Ref: http://dev.mysql.com/doc/refman/5.7/en/blob.html ->" BLOB and TEXT columns cannot have DEFAULT values."
I get this one using --show-warnings on MariaDB 10.0.24 Fixed with diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 42bff46..ea220bb 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -69,7 +69,7 @@ CREATE TABLE `auth_subfield_structure` ( `linkid` tinyint(1) NOT NULL default 0, `kohafield` varchar(45) NULL default '', `frameworkcode` varchar(10) NOT NULL default '', - `defaultvalue` TEXT DEFAULT '', + `defaultvalue` TEXT, But I don't get the others
MySQL 5.7 does not like things like that. Perhaps we can change the sql_mode for Koha globally, or fix all the sample data (not difficult) in all languages, and test/sign/QA everything... before release?
Yes, on another bug report. Now you have Ubuntu 16.04, could you please submit a patch? :) -- You are receiving this mail because: You are watching all bug changes.