From 70625c7969d1761c43303eb768340e88d419a4c8 Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Sun, 9 Apr 2017 16:47:21 +1000 Subject: [PATCH] Add in Upgrade script for CRM-20402 --- CRM/Upgrade/Incremental/sql/4.7.19.mysql.tpl | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.19.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.19.mysql.tpl index cadc65e378..c0c90d2888 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.19.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.19.mysql.tpl @@ -24,3 +24,7 @@ WHERE price_field.price_field_id IS NULL; -- CRM-20400 {include file='../CRM/Upgrade/4.7.19.msg_template/civicrm_msg_template.tpl'} + +-- CRM-20402 Improve dectection of spam bounces +SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Spam'; +UPDATE civicrm_mailing_bounce_pattern SET pattern = '(detected|rejected) (as|due to) spam' WHERE bounce_type_id = @bounceTypeID AND pattern = '(detected|rejected) as spam'; -- 2.25.1