You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.
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.
The text was updated successfully, but these errors were encountered:
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 :
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 :
IS-it a problem about a version of one composant ?
Thanks for help.
The text was updated successfully, but these errors were encountered: