@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_27726.perl | 6 ++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_27726.perl --- a/installer/data/mysql/atomicupdate/bug_27726.perl +++ a/installer/data/mysql/atomicupdate/bug_27726.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do("ALTER TABLE problem_reports MODIFY content TEXT NOT NULL DEFAULT ''"); + + NewVersion( $DBversion, 27726, "Increase field size for problem_reports.content"); +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -4132,7 +4132,7 @@ DROP TABLE IF EXISTS `problem_reports`; CREATE TABLE `problem_reports` ( `reportid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha', `title` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report subject line', - `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report message content', + `content` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report message content', `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'the user who created the problem report', `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'borrower''s branch', `username` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'OPAC username', --