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