From 611e3e1ebb36543aff9dda17d913a83eb370d91e Mon Sep 17 00:00:00 2001 From: Michael Hafen Date: Tue, 16 Dec 2025 11:40:30 -0700 Subject: [PATCH] Bug 41460: Remove default value from mediumtext column systempreferences.value Content-Type: text/plain; charset="utf-8" Mysql doesn't allow text type columns to have a default. --- installer/data/mysql/db_revs/250600005.pl | 2 +- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/db_revs/250600005.pl b/installer/data/mysql/db_revs/250600005.pl index b0aeb88ff2..3de6d1b7ee 100755 --- a/installer/data/mysql/db_revs/250600005.pl +++ b/installer/data/mysql/db_revs/250600005.pl @@ -23,7 +23,7 @@ return { $dbh->do( q{ ALTER TABLE systempreferences - MODIFY COLUMN `value` mediumtext NOT NULL DEFAULT '' COMMENT 'system preference values' + MODIFY COLUMN `value` mediumtext NOT NULL COMMENT 'system preference values' } ); }, diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e65b2af7ca..be98f8bcf4 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -6677,7 +6677,7 @@ DROP TABLE IF EXISTS `systempreferences`; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `systempreferences` ( `variable` varchar(50) NOT NULL DEFAULT '' COMMENT 'system preference name', - `value` mediumtext NOT NULL DEFAULT '' COMMENT 'system preference values', + `value` mediumtext NOT NULL COMMENT 'system preference values', `options` longtext DEFAULT NULL COMMENT 'options for multiple choice system preferences', `explanation` mediumtext DEFAULT NULL COMMENT 'descriptive text for the system preference', `type` varchar(20) DEFAULT NULL COMMENT 'type of question this preference asks (multiple choice, plain text, yes or no, etc)', -- 2.43.0