From e09cfd5d55291b6046272bd45d53a9dab5d8c668 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 30 Apr 2021 07:50:26 +0000 Subject: [PATCH] Bug 28258: DBRev 20.12.00.043 Signed-off-by: Jonathan Druart --- Koha.pm | 2 +- .../bug_28258_update_auto_renewals_template.perl | 10 ---------- installer/data/mysql/updatedatabase.pl | 11 +++++++++++ 3 files changed, 12 insertions(+), 11 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl diff --git a/Koha.pm b/Koha.pm index b1cad76c63..4bf0aea297 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 = "20.12.00.042"; +$VERSION = "20.12.00.043"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl b/installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl deleted file mode 100644 index 612c20cac5..0000000000 --- a/installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl +++ /dev/null @@ -1,10 +0,0 @@ -$DBversion = 'XXX'; # will be replaced by the RM -if( CheckVersion( $DBversion ) ) { - $dbh->do(q{ - UPDATE letter SET - content = REPLACE(content, "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due as_due_date => 1 %]" , "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]") - WHERE code = 'AUTO_RENEWALS'; - }); - - NewVersion( $DBversion, 28258, "Update AUTO_RENEWAL content"); -} diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 6856e66342..1262860fa3 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -24166,6 +24166,17 @@ if( CheckVersion( $DBversion ) ) { NewVersion( $DBversion, 17202, "Add FK constraint for collection to collections_tracking"); } +$DBversion = '20.12.00.043'; +if( CheckVersion( $DBversion ) ) { + $dbh->do(q{ + UPDATE letter SET + content = REPLACE(content, "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due as_due_date => 1 %]" , "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]") + WHERE code = 'AUTO_RENEWALS'; + }); + + NewVersion( $DBversion, 28258, "Update AUTO_RENEWAL content"); +} + # SEE bug 13068 # if there is anything in the atomicupdate, read and execute it. my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/'; -- 2.39.5