@@ -, +, @@ --- installer/data/mysql/atomicupdate/Bug_29138.pl | 9 +++------ 1 file changed, 3 insertions(+), 6 deletions(-) --- a/installer/data/mysql/atomicupdate/Bug_29138.pl +++ a/installer/data/mysql/atomicupdate/Bug_29138.pl @@ -6,12 +6,9 @@ return { up => sub { my ($args) = @_; my ($dbh, $out) = @$args{qw(dbh out)}; - # Do you stuffs here $dbh->do(q{ - UPDATE systempreferences SET value= IF(value='no',0,1) - WHERE variable = 'LoadSearchHistoryToTheFirstLoggedUser'; - }); - # Print useful stuff here - say $out "LoadSearchHistoryToTheFirstLoggedUser updated"; + UPDATE systempreferences SET value=0 + WHERE variable='LoadSearchHistoryToTheFirstLoggedUser' AND IFNULL(value,0)<>1; + }); }, } --