Skip to content
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.

Error during initial import of the data #5326

Closed
openstreetmap-trac opened this issue Jul 23, 2021 · 1 comment
Closed

Error during initial import of the data #5326

openstreetmap-trac opened this issue Jul 23, 2021 · 1 comment

Comments

@openstreetmap-trac
Copy link

Reporter: sylvain.ballaud.externe[at]cnp.fr
[Submitted to the original trac issue database at 12.42pm, Thursday, 2nd July 2015]

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.

@openstreetmap-trac
Copy link
Author

Author: lonvia
[Added to the original trac issue at 9.24pm, Thursday, 2nd July 2015]

Postgres 8.4 is no longer supported, please use at least 9.0, preferably 9.3 or 9.4.

For CentOS/RedHat, there are detailed installation instructions at: http://wiki.openstreetmap.org/wiki/Nominatim/Installation/CentOS

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant