Attachment 94716 Details for Bug 23579 – Bug 23579: Remove default value for MEDIUMTEXT borrower_modifications.changed_fields

[patch] Bug 23579: Remove default value for MEDIUMTEXT borrower_modifications.changed_fields

Bug-23579-Remove-default-value-for-MEDIUMTEXT-borr.patch (text/plain), 1.46 KB, created by Jonathan Druart on 2019-10-25 08:18:55 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2019-10-25 08:18:55 UTC

Size: 1.46 KB

patch

obsolete

>From 5f63768fd594256c992b83999864db50964b78e2 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>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

Actions: View | Diff | Splinter Review

Attachments on bug 23579: 94716 | 94718 | 94747