@@ -, +, @@ subscription_numberpatterns C4::Serials::Numberpattern::AddSubscriptionNumberpattern(): DBI Exception: DBD::mysql::st execute failed: Field 'description' doesn't have a default value at /kohadevbox/koha/serials/create-numberpattern.pl line 58 --- ...ULL_description_in_serial_numberpatterns.pl | 18 ++++++++++++++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 19 insertions(+), 1 deletion(-) create mode 100755 installer/data/mysql/atomicupdate/bug_31297_allow_NULL_description_in_serial_numberpatterns.pl --- a/installer/data/mysql/atomicupdate/bug_31297_allow_NULL_description_in_serial_numberpatterns.pl +++ a/installer/data/mysql/atomicupdate/bug_31297_allow_NULL_description_in_serial_numberpatterns.pl @@ -0,0 +1,18 @@ +use Modern::Perl; + +return { + bug_number => "31297", + description => "Allow subscription number pattern description to be NULL", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + $dbh->do(q{ + ALTER TABLE subscription_numberpatterns MODIFY description mediumtext DEFAULT NULL + }); + + say $out "Added new table 'XXX'"; + say $out "Modified column 'subscription_numberpatterns.description' to allow and default to NULL"; + + }, +}; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -6018,7 +6018,7 @@ CREATE TABLE `subscription_numberpatterns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `label` varchar(255) NOT NULL, `displayorder` int(11) DEFAULT NULL, - `description` mediumtext NOT NULL, + `description` mediumtext DEFAULT NULL, `numberingmethod` varchar(255) NOT NULL, `label1` varchar(255) DEFAULT NULL, `add1` int(11) DEFAULT NULL, --