https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
--- Comment #50 from Jonathan Druart <jonathan.dru...@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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/