From 5e6b81899b609cefb61731c32f846a106d2c4ddb 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.11.05.003 Signed-off-by: Jonathan Druart (cherry picked from commit e09cfd5d55291b6046272bd45d53a9dab5d8c668) Signed-off-by: Fridolin Somers --- 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 3eacc5bb3e..d50f8d600f 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.11.05.002"; +$VERSION = "20.11.05.003"; 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 1f4873082f..328c08923e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -23559,6 +23559,17 @@ if( CheckVersion( $DBversion ) ) { NewVersion( $DBversion, 20854, "Add new system preference casServerVersion"); } +$DBversion = '20.11.05.003'; +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