@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_29386.pl | 14 ++++++++++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 15 insertions(+), 1 deletion(-) create mode 100755 installer/data/mysql/atomicupdate/bug_29386.pl --- a/installer/data/mysql/atomicupdate/bug_29386.pl +++ a/installer/data/mysql/atomicupdate/bug_29386.pl @@ -0,0 +1,14 @@ +use Modern::Perl; + +return { + bug_number => "29386", + description => "Extend background_jobs.data to LONGTEXT", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + $dbh->do(q| + ALTER TABLE background_jobs + CHANGE COLUMN `data` `data` LONGTEXT DEFAULT NULL + |); + }, +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -944,7 +944,7 @@ CREATE TABLE `background_jobs` ( `size` int(11) DEFAULT NULL, `borrowernumber` int(11) DEFAULT NULL, `type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `data` LONGTEXT COLLATE utf8mb4_unicode_ci DEFAULT NULL, `enqueued_on` datetime DEFAULT NULL, `started_on` datetime DEFAULT NULL, `ended_on` datetime DEFAULT NULL, --