From 5f63768fd594256c992b83999864db50964b78e2 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 25 Oct 2019 10:15:42 +0200 Subject: [PATCH] Bug 23579: Remove default value for MEDIUMTEXT borrower_modifications.changed_fields Installation under Ubuntu 18.04 is blocked: install.pl: DBD::mysql::st execute failed: BLOB, TEXT, GEOMETRY or JSON column 'changed_fields' can't have a default value at /usr/local/share/perl5/DBIx/RunSQL.pm line 273. https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html """ The BLOB, TEXT, GEOMETRY, and JSON data types cannot be assigned a default value. """ --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 7073c9a2d1..309a1da225 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3341,7 +3341,7 @@ CREATE TABLE borrower_attribute_types_branches( -- association table between bor CREATE TABLE IF NOT EXISTS `borrower_modifications` ( `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `verification_token` varchar(255) NOT NULL DEFAULT '', - `changed_fields` MEDIUMTEXT NOT NULL DEFAULT '', + `changed_fields` MEDIUMTEXT NOT NULL, `borrowernumber` int(11) NOT NULL DEFAULT '0', `cardnumber` varchar(32) DEFAULT NULL, `surname` LONGTEXT, -- 2.11.0