From e87dcc7b20ce03753abe2ac737f97c52a45d5daa Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 8 Nov 2021 11:38:35 +0100 Subject: [PATCH] Bug 24224: DBRev 21.06.00.046 Signed-off-by: Jonathan Druart --- Koha.pm | 2 +- .../210600046.pl} | 6 +----- 2 files changed, 2 insertions(+), 6 deletions(-) rename installer/data/mysql/{atomicupdate/bug_24224-move-opacnavbottom-to-news.pl => db_revs/210600046.pl} (64%) diff --git a/Koha.pm b/Koha.pm index be06969792..8f60e2f713 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.045"; +$VERSION = "21.06.00.046"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/bug_24224-move-opacnavbottom-to-news.pl b/installer/data/mysql/db_revs/210600046.pl similarity index 64% rename from installer/data/mysql/atomicupdate/bug_24224-move-opacnavbottom-to-news.pl rename to installer/data/mysql/db_revs/210600046.pl index 47ff4c8f0c..2f3202db1f 100755 --- a/installer/data/mysql/atomicupdate/bug_24224-move-opacnavbottom-to-news.pl +++ b/installer/data/mysql/db_revs/210600046.pl @@ -13,14 +13,10 @@ return { |); if( $opacnavbottom ){ # If there is a value in the OpacNavBottom preference, insert it into additional_contents - foreach my $lang ( 'default' ) { - say $out "Inserting OpacNavBottom contents into default"; - $dbh->do( "INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on ) VALUES ('html_customizations', 'OpacNavBottom', 'OpacNavBottom', NULL, ?, ?, ?, CAST(NOW() AS date) )", undef, "OpacNavBottom $lang", $opacnavbottom, $lang ); - } + $dbh->do( "INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on ) VALUES ('html_customizations', 'OpacNavBottom', 'OpacNavBottom', NULL, ?, ?, 'default', CAST(NOW() AS date) )", undef, "OpacNavBottom default", $opacnavbottom ); # Remove the OpacNavBottom system preference $dbh->do("DELETE FROM systempreferences WHERE variable='OpacNavBottom'"); - say $out "Bug 24223 update done"; } else { say $out "No OpacNavBottom preference found. Update has already been run."; } -- 2.20.1