X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2Fmerge_issues_geocoding.php;h=df98463d82ac739e074657d1a6df89ef3905f7b7;hb=69d311a9e667ba071af1070cfe9a6906a4f0ed32;hp=6f9016e815eb94b48498a2252f6f6de72119d87c;hpb=164566891eef6e4027b2dfccda0040d37f10605b;p=platal.git

diff --git a/upgrade/1.0.1/merge_issues_geocoding.php b/upgrade/1.0.1/merge_issues_geocoding.php
index 6f9016e..df98463 100755
--- a/upgrade/1.0.1/merge_issues_geocoding.php
+++ b/upgrade/1.0.1/merge_issues_geocoding.php
@@ -9,12 +9,14 @@ $globals->debug = 0; // Do not store backtraces.
 
 print "Tries to geocode addresses (due a bug in the previous release, all addresses must run once again).\n";
 $time = XDB::fetchOneCell('SELECT  COUNT(distinct(pid), jobid)
-                             FROM  profile_addresses');
+                             FROM  profile_addresses
+                            WHERE  accuracy IS NOT NULL AND accuracy > 0');
 $time = ceil($time / 60 / 24);
 print "It will approximately take $time days.\n";
 
 $it = XDB::rawIterator('SELECT  *
                           FROM  profile_addresses
+                         WHERE  accuracy IS NOT NULL AND accuracy > 0
                       ORDER BY  pid, jobid, type, id');
 $total = $it->total();
 $i = 0;