From ccaa25a70d164e05084150cb025bff56af457e0d Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 12 Oct 2021 11:14:38 +0200 Subject: [PATCH] Bug 29138: DBRev 21.06.00.032 Signed-off-by: Jonathan Druart --- Koha.pm | 2 +- .../mysql/{atomicupdate/Bug_29138.pl => db_revs/210600032.pl} | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) rename installer/data/mysql/{atomicupdate/Bug_29138.pl => db_revs/210600032.pl} (70%) diff --git a/Koha.pm b/Koha.pm index 2f711962b0..93242c86ec 100644 --- a/Koha.pm +++ b/Koha.pm @@ -29,7 +29,7 @@ use vars qw{ $VERSION }; # - #4 : the developer version. The 4th number is the database subversion. # used by developers when the database changes. updatedatabase take care of the changes itself # and is automatically called by Auth.pm when needed. -$VERSION = "21.06.00.031"; +$VERSION = "21.06.00.032"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/Bug_29138.pl b/installer/data/mysql/db_revs/210600032.pl similarity index 70% rename from installer/data/mysql/atomicupdate/Bug_29138.pl rename to installer/data/mysql/db_revs/210600032.pl index 8261ce111b..f9121ae61a 100755 --- a/installer/data/mysql/atomicupdate/Bug_29138.pl +++ b/installer/data/mysql/db_revs/210600032.pl @@ -2,13 +2,13 @@ use Modern::Perl; return { bug_number => "29138", - description => "Use a zero instead of a no in LoadSearchHistoryToTheFirstLoggedUser", + description => "Use a zero instead of a 'no' in LoadSearchHistoryToTheFirstLoggedUser", up => sub { my ($args) = @_; my ($dbh, $out) = @$args{qw(dbh out)}; $dbh->do(q{ UPDATE systempreferences SET value='0' - WHERE variable='LoadSearchHistoryToTheFirstLoggedUser' AND COALESCE(value,'0')<>'1'; + WHERE variable='LoadSearchHistoryToTheFirstLoggedUser' AND value='no'; }); }, } -- 2.20.1