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