@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_33567.pl | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_33567.pl --- a/installer/data/mysql/atomicupdate/bug_33567.pl +++ a/installer/data/mysql/atomicupdate/bug_33567.pl @@ -0,0 +1,17 @@ +use Modern::Perl; + +return { + bug_number => 33567, + description => "Replace empty Reference_NFL_Statuses pref", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + + my $rv = $dbh->do(q{ + UPDATE systempreferences SET value='1|2' + WHERE variable = 'Reference_NFL_Statuses' AND COALESCE(value,'')='' + }); + say $out "Updated preference Reference_NFL_Statuses to default" + if $rv && $rv == 1; + }, +}; --