@@ -, +, @@
---
installer/data/mysql/atomicupdate/bug_21066b.perl | 9 +++++++++
installer/data/mysql/en/mandatory/sample_notices.yml | 2 +-
installer/data/mysql/en/optional/sample_news.yml | 4 ++--
t/db_dependent/Letters/TemplateToolkit.t | 4 +++-
4 files changed, 15 insertions(+), 4 deletions(-)
create mode 100644 installer/data/mysql/atomicupdate/bug_21066b.perl
--- a/installer/data/mysql/atomicupdate/bug_21066b.perl
+++ a/installer/data/mysql/atomicupdate/bug_21066b.perl
@@ -0,0 +1,9 @@
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q|
+ UPDATE letter
+ SET content = REPLACE(content,?,?)
+ WHERE content LIKE ?
+ |, undef, 'opac_news.timestamp', 'opac_news.publicationdate', '%opac_news.timestamp%' );
+ NewVersion( $DBversion, 21066, "Replace timestamp references in letters table");
+}
--- a/installer/data/mysql/en/mandatory/sample_notices.yml
+++ a/installer/data/mysql/en/mandatory/sample_notices.yml
@@ -505,7 +505,7 @@ tables:
- "
"
- "
<>
"
- "
<>
"
- - ""
+ - ""
- "
"
- "
"
- ""
--- a/installer/data/mysql/en/optional/sample_news.yml
+++ a/installer/data/mysql/en/optional/sample_news.yml
@@ -29,7 +29,7 @@ tables:
content:
- "Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe."
lang: "koha"
- timestamp: "2007-10-29 05:25:58"
+ publicationdate: "2007-10-29 05:25:58"
expirationdate: "2099-01-10"
number: 1
@@ -46,6 +46,6 @@ tables:
- ""
- ""
lang: "koha"
- timestamp: "2007-10-29 05:34:45"
+ publicationdate: "2007-10-29 05:34:45"
expirationdate: "2099-01-10"
number: 2
--- a/t/db_dependent/Letters/TemplateToolkit.t
+++ a/t/db_dependent/Letters/TemplateToolkit.t
@@ -667,7 +667,7 @@ Date due: <>
@@ -1174,3 +1174,5 @@ sub process_letter {
);
return $letter;
}
+
+$schema->storage->txn_rollback;
--