From b96efb1b13412304a47a2f0b0b5979f3cf8be910 Mon Sep 17 00:00:00 2001 From: Andrew Fuerste-Henry Date: Tue, 25 May 2021 11:35:46 +0000 Subject: [PATCH] Bug 28258: DBRev 20.05.11.003 Signed-off-by: Andrew Fuerste-Henry --- Koha.pm | 2 +- .../bug_28258_update_auto_renewals_template.perl | 10 ---------- installer/data/mysql/updatedatabase.pl | 12 +++++++++++- 3 files changed, 12 insertions(+), 12 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl diff --git a/Koha.pm b/Koha.pm index 8c9884718f..74a82a6ebe 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.05.11.002"; +$VERSION = "20.05.11.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 5551c095c3..110b9fe8f4 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -22635,10 +22635,20 @@ if( CheckVersion( $DBversion ) ) { $dbh->do( "INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('casServerVersion', '2', '2|3', 'Version of the CAS server Koha will connect to.', 'Choice');"); - # Always end with this (adjust the bug info) NewVersion( $DBversion, 20854, "Adds a casServerVersion system preference"); } +$DBversion = '20.05.11.003'; # 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"); +} + # 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