From 37683ffd695f6cc0c356325e8b9f2c2a516e1477 Mon Sep 17 00:00:00 2001 From: Emily Lamancusa Date: Fri, 28 Jun 2024 17:02:50 -0400 Subject: [PATCH] Bug 37216: (follow-up) Clear invalid value Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug_37216.pl | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_37216.pl b/installer/data/mysql/atomicupdate/bug_37216.pl index e773122adf..115868b20d 100755 --- a/installer/data/mysql/atomicupdate/bug_37216.pl +++ b/installer/data/mysql/atomicupdate/bug_37216.pl @@ -8,11 +8,16 @@ return { my ($args) = @_; my ( $dbh, $out ) = @$args{qw(dbh out)}; - # Do you stuffs here + # Fix options field on EmailFieldSelection $dbh->do( q{ UPDATE systempreferences SET options = 'email|emailpro|B_email' WHERE variable = 'EmailFieldSelection' } ); + # Clear invalid value from EmailFieldSelection + $dbh->do( + q{ UPDATE systempreferences SET value = '' WHERE variable = 'EmailFieldSelection' AND value='email|emailpro|B_email' } + ); + say_success( $out, "Updated system preference 'EmailFieldSelection'" ); }, }; -- 2.39.5