Eileen has uploaded a new change for review.
https://gerrit.wikimedia.org/r/320564
Change subject: Re-run lat/long update to existing addresses.
......................................................................
Re-run lat/long update to existing addresses.
Bug: T150305
Change-Id: I161f5b35cdedfacecc42ce17cb3bc727628a6784
---
M sites/all/modules/wmf_civicrm/wmf_civicrm.install
1 file changed, 14 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm
refs/changes/64/320564/1
diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
index 6f0150e..a021ccd 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.install
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.install
@@ -2375,8 +2375,8 @@
CREATE TEMPORARY TABLE civicrm_address_geocode (
id INT PRIMARY KEY,
zip CHAR(5),
- latitude DOUBLE,
- longitude DOUBLE,
+ latitude DECIMAL (13,9),
+ longitude DECIMAL (13,9),
timezone VARCHAR(8)
)");
@@ -2427,3 +2427,15 @@
");
}
+
+/**
+ * Re-run lat/long update to existing addresses.
+ *
+ * The above function has been edited to store decimals rather than doubles in
the
+ * temp table. This was (wierdly) adding extra digits.
+ *
+ * T150305
+ */
+function wmf_civicrm_update_7330() {
+ wmf_civicrm_update_7320();
+}
--
To view, visit https://gerrit.wikimedia.org/r/320564
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I161f5b35cdedfacecc42ce17cb3bc727628a6784
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
