Eileen has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/341486 )
Change subject: Remove geocoding blank addresses.
......................................................................
Remove geocoding blank addresses.
This turned out to be a bit of a red herring, since only 130 are in our tables,
but
let's treat the geocoding updates as a non-update
Change-Id: I1478363fc5ac7b599dc749eff57c46a974638197
---
M sites/all/modules/wmf_civicrm/wmf_civicrm.install
1 file changed, 16 insertions(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm
refs/changes/86/341486/1
diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
index 1063ea6..eecbdb4 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
@@ -2648,7 +2648,9 @@
INNER JOIN civicrm_address a
ON a.id = b.id
LEFT JOIN log_civicrm_address c
- ON c.id = b.id AND c.log_action <> b.log_action
+ ON c.id = b.id
+ AND c.log_action <> b.log_action
+ AND c.log_conn_id NOT IN( '581939a5f3bc8', '5823950b11501')
WHERE
a.street_address IS NULL
AND a.city IS NULL
@@ -2739,3 +2741,16 @@
);
}
+
+/**
+ *
+ * Remove blank addresses relating to geocode update from tracking table.
+ *
+ * There is a small number of addresses (only 130) which were only updated
+ * as part of the geocoding updates. Remove these to be less confusing.
+ *
+ * Bug: T159396
+ */
+function wmf_civicrm_update_7495() {
+ CRM_Core_DAO::executeQuery("DELETE FROM blank_addresses WHERE log_conn_id IN
('581939a5f3bc8', '5823950b11501')");
+}
--
To view, visit https://gerrit.wikimedia.org/r/341486
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I1478363fc5ac7b599dc749eff57c46a974638197
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
