[Geocoding] [OpenStreetMap] #5328: Error during initial import of the data

[OpenStreetMap]

#5328: Error during initial import of the data
---------------------------------------+-------------------------
 Reporter:  sylvain.ballaud.externe@…  |      Owner:  geocoding@…
     Type:  defect                     |     Status:  new
 Priority:  blocker                    |  Milestone:
Component:  nominatim                  |    Version:
 Keywords:                             |
---------------------------------------+-------------------------
 Hi,

 I installed Nominatim 2.4 on a Red Hat Enterprise Linux 6.6. I also
 installed PostgreSQL 8.4.20 and PostGIS 1.5.3-1. The version of Apache is
 2.2.15 and PHP is 5.3.3.

 My problem is when i try to import data (for example a sub region in
 France called Ile-de-France on http://download.geofabrik.de/), I have this
 error when i launched it with the user postgres :

 {{{
 -bash-4.1$ /soft/nominatim/utils/setup.php --osm-file /soft/nominatim/data
 /ile-de-france-latest.osm.pbf --all 2>&1 | tee setup.log
 ..............................
 CREATE TABLE
 ERROR:  syntax error at or near ")"
 LINE 1: create type wikipedia_article_match as ()
                                                 ^
 ERROR: pgsql returned with error code (3)
 pgsql returned with error code (3)
 }}}

 When i commented the line "create type wikipedia_article_match as ()" on
 the setup.php file or when i changed this line with "create type
 wikipedia_article_match", the import continued but I have a other error :

 {{{
 WARNING:  nonstandard use of escape in a string literal
 LINE 1: SELECT   $1  ~ '^\d+$'
                        ^
 HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
 QUERY:  SELECT   $1  ~ '^\d+$'
 CONTEXT:  SQL statement in PL/PgSQL function "create_interpolation" near
 line 27
 ERROR:  syntax error at or near "$1"
 LINE 1: insert into placex (place_id,  $1 , osm_type, osm_id, class,...
                                        ^
 QUERY:  insert into placex (place_id,  $1 , osm_type, osm_id, class, type,
 admin_level, housenumber, postcode,  $2 , parent_place_id, rank_address,
 rank_search, indexed_status, indexed_date,  $3 , calculated_country_code,
 centroid, geometry) values (nextval('seq_place'),  $1 , 'W',  $4 ,
 'place', 'address',  $5 ,  $6 , coalesce( $7 ,  $8 ),  $9 ,  $10 , 30, 30,
 0, now(),  $3 ,  $2 ,  $11 ,  $11 )
 CONTEXT:  SQL statement in PL/PgSQL function "create_interpolation" near
 line 104
 ERROR: pgsql returned with error code (3)
 pgsql returned with error code (3)
 }}}

 IS-it a problem about a version of one composant ?

 Thanks for help.

--
Ticket URL: <https://trac.openstreetmap.org/ticket/5328>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world