From c1c370a71617519efa00c9bb654d505361c6508f Mon Sep 17 00:00:00 2001 From: Kemal Bay Date: Sun, 8 Nov 2015 15:34:20 +0200 Subject: [PATCH] CRM-17147 People with empty deceased-flag ('is null') get removed from recipient list of a mailing --- CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl index 8348cb5d3a..6f1df6a2e1 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl @@ -4,4 +4,6 @@ SELECT @parent_id := id from `civicrm_navigation` where name = 'Administration C INSERT INTO civicrm_navigation ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) VALUES -( {$domainID}, 'civicrm/a/#/status', '{ts escape="sql" skip="true"}System Status{/ts}', 'System Status', 'administer CiviCRM', '', @parent_id, '1', NULL, 0 ); \ No newline at end of file +( {$domainID}, 'civicrm/a/#/status', '{ts escape="sql" skip="true"}System Status{/ts}', 'System Status', 'administer CiviCRM', '', @parent_id, '1', NULL, 0 ); + +UPDATE civicrm_contact SET is_deceased = 0 WHERE is_deceased IS NULL; \ No newline at end of file -- 2.25.1