From 8b7037c08efb287ec90cde2a039a11b8ae67c92f Mon Sep 17 00:00:00 2001 From: yashodha Date: Tue, 29 Nov 2016 12:25:10 +0530 Subject: [PATCH] CRM-19685: Contacts preferred_mail_format can't be NULL --- CRM/Upgrade/Incremental/sql/4.7.15.mysql.tpl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.15.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.15.mysql.tpl index a6ce4cb718..4995379ef5 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.15.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.15.mysql.tpl @@ -1 +1,4 @@ {* file to handle db changes in 4.7.15 during upgrade *} + +-- CRM-19685 (fix for inconsistencies) +UPDATE civicrm_contact SET preferred_mail_format = 'Both' WHERE preferred_mail_format IS NULL; \ No newline at end of file -- 2.25.1