Eileen has uploaded a new change for review.
https://gerrit.wikimedia.org/r/311885
Change subject: Revise update to primaries not set.
......................................................................
Revise update to primaries not set.
This worked on staging but it must be missing some triggers as it failed on a
circularity on prod.
The temporary table should get past that
Bug: T143062
Change-Id: I73ecc0da3b89ea45db3cd4a1f6841ad850369d36
---
M sites/all/modules/wmf_civicrm/wmf_civicrm.install
1 file changed, 7 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm
refs/changes/85/311885/1
diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
index 9aeb973..78b227f 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
@@ -2202,14 +2202,18 @@
function wmf_civicrm_update_7250() {
civicrm_initialize();
CRM_Core_DAO::executeQuery("
- UPDATE civicrm_email SET is_primary = 1
- WHERE id IN (SELECT id FROM
+ CREATE TEMPORARY TABLE civicrm_email_updates
+ SELECT id FROM
(
SELECT contact_id, sum(is_primary) as c, e.id
FROM civicrm_email e
INNER JOIN civicrm_contact c ON c.id = contact_id AND is_deleted = 0
GROUP BY contact_id HAVING c = 0
) as i
- )
+ ");
+
+ CRM_Core_DAO::executeQuery("ALTER TABLE civicrm_email_updates ADD INDEX
index_id(id)");
+ CRM_Core_DAO::executeQuery("UPDATE civicrm_email e INNER JOIN
civicrm_email_updates u ON e.id = u.id
+ SET e.is_primary = 1
");
}
--
To view, visit https://gerrit.wikimedia.org/r/311885
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I73ecc0da3b89ea45db3cd4a1f6841ad850369d36
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Eileen <emcnaugh...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
