[Geocoding] Error importing osm file, index_placex: UPDATE failed: ERROR: upper bound of FOR loop cannot be null]

[Adrian Chapela]

El 29/06/12 11:56, Sarah Hoffmann escribió:
> This was meant to go to the list...
>
> ----- Forwarded message from Sarah Hoffmann <lonvia at denofr.de> -----
>
> Hi Adrian,
>
> On Fri, Jun 29, 2012 at 11:22:12AM +0200, Adrian Chapela wrote:
>> I am folling instructions of:
>> http://wiki.openstreetmap.org/wiki/Nominatim/Installation
>>
>> At step ./utils/setup.php (importing database) the import never ends because it is sending the next error:
>> index_placex: UPDATE failed: ERROR:  upper bound of FOR loop cannot be null
>> CONTEXT:  PL/pgSQL function "get_osm_rel_members" line 6 at FOR with integer loop variable
>> PL/pgSQL function "placex_update" line 312 at FOR over SELECT rows
>>
>> The problem is when setup.php execute the next:
>> nominatim -i -d nominatim -t 3 -R 4
>>
>> I am using osm2pgsql 0.80 and osmosis 0.40.1
> Your osm2pgsql is most likely too old. 
As I can see (after done a new git clone) the osm2pgsql is the same
version that I have used to import yesterday, 0.80. Now I have compiled
again with 64 bits activated.
> Try out the very latest version
> of Nominatim from git. It comes bundled with the correct version of
> osm2pgsql. Please note that the compilation instructions have changed
> slightly. The wiki site has been updated.
Yesterday at 19:14!! This can not be true! And maybe this change og
functions.sql resolve my problems.

diff --git a/sql/functions.sql b/sql/functions.sql
index 554ddf3..20e97c1 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1739,7 +1739,7 @@ DECLARE
   b BOOLEAN;
   classtable TEXT;
 BEGIN
-  RAISE WARNING 'placex_delete % %',OLD.osm_type,OLD.osm_id;
+  -- RAISE WARNING 'placex_delete % %',OLD.osm_type,OLD.osm_id;
 
   update placex set linked_place_id = null where linked_place_id =
OLD.place_id;
   --DEBUG: RAISE WARNING 'placex_delete:01 % %',OLD.osm_type,OLD.osm_id;

Regards!

>
> Sarah
>
>
> _______________________________________________
> Geocoding mailing list
> Geocoding at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/geocoding
>