[Koha-bugs] [Bug 13669] Web installer fails to load sample data on MySQL 5.6+
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon May 23 13:17:49 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
--- Comment #50 from Jonathan Druart <jonathan.druart at 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.
More information about the Koha-bugs
mailing list