From a416cad2b7b343f9bf766ccca826c5334e0c1372 Mon Sep 17 00:00:00 2001 From: demeritcowboy Date: Tue, 18 Jul 2023 15:49:01 -0400 Subject: [PATCH] be more literal --- CRM/Upgrade/Incremental/sql/5.65.alpha1.mysql.tpl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/5.65.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.65.alpha1.mysql.tpl index 737485d82f..fb4aa74bf4 100644 --- a/CRM/Upgrade/Incremental/sql/5.65.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.65.alpha1.mysql.tpl @@ -24,8 +24,10 @@ UPDATE civicrm_group SET `name` = `id` WHERE name IS NULL; WHERE `frontend_description` IS NULL OR `frontend_description` = '' AND description <> ''; {/if} +{literal} UPDATE civicrm_mailing_component SET body_html = REPLACE(body_html, '{welcome.group}', '{group.frontend_title}'), body_text = REPLACE(body_text, '{welcome.group}', '{group.frontend_title}'), subject = REPLACE(subject, '{welcome.group}', '{group.frontend_title}') WHERE component_type = 'Welcome'; +{/literal} -- 2.25.1