Fixes names captitalization and sorting.

[platal.git] / upgrade / 1.1.2 / xx_retrieve_geocoding.sql

diff --git a/upgrade/1.1.2/xx_retrieve_geocoding.sql b/upgrade/1.1.2/xx_retrieve_geocoding.sql
index 95da5cd..c239207 100644 (file)
--- a/upgrade/1.1.2/xx_retrieve_geocoding.sql
+++ b/upgrade/1.1.2/xx_retrieve_geocoding.sql
@@ -1,6 +1,6 @@
     UPDATE  profile_addresses     AS pa
 INNER JOIN  tmp_profile_addresses AS ta ON (pa.pid = ta.pid AND pa.jobid = ta.jobid AND pa.groupid = ta.groupid AND pa.type = ta.type AND pa.text = ta.text)
-       SET  pa.id = ta.id, pa.postalText = ta.postalText, pa.formatted_address = ta.formatted_address, pa.types = ta.types,
+       SET  pa.postalText = ta.postalText, pa.formatted_address = ta.formatted_address, pa.types = ta.types,
             pa.latitude = ta.latitude, pa.longitude = ta.longitude, pa.southwest_latitude = ta.southwest_latitude,
             pa.southwest_longitude = ta.southwest_longitude, pa.northeast_latitude = ta.northeast_latitude, pa.northeast_longitude = ta.northeast_longitude,
             pa.location_type = ta.location_type, pa.partial_match = ta.partial_match,