Bug 28374: (QA follow-up) Avoid adding duplicate USE

[srvgit] / installer / data / mysql / atomicupdate / bug_28374.pl

diff --git a/installer/data/mysql/atomicupdate/bug_28374.pl b/installer/data/mysql/atomicupdate/bug_28374.pl
index bc03104..049dce3 100755 (executable)
--- a/installer/data/mysql/atomicupdate/bug_28374.pl
+++ b/installer/data/mysql/atomicupdate/bug_28374.pl
@@ -8,7 +8,11 @@ return {
         my ($dbh, $out) = @$args{qw(dbh out)};
 
         $dbh->do(q{
-            UPDATE letter SET content = CONCAT('[% USE KohaDates %][% USE Branches %][% USE Price %]', content), is_html = 1 WHERE code = 'RECEIPT';
+            UPDATE letter
+                SET content = CONCAT('[% USE KohaDates %][% USE Branches %][% USE Price %]', content),
+                    is_html = 1
+            WHERE   code = 'RECEIPT'
+                AND content NOT LIKE '%[\% USE KohaDates \%][\% USE Branches \%][\% USE Price \%]%';
         });
         say $out "Added KohaDates, Branches and Price plugins";