NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi for all. When I run:

$ ./setup.php --osm-file poland.osm.bz2 --all

script is running until:

...

Strict Standards: Non-static method DB::isError() should not be called statically in /usr/share/php/DB.php on line 557 PHP Strict Standards: Non-static method PEAR::isError() should not be called statically in /home/nominatim/lib/db.php on line 8

Strict Standards: Non-static method PEAR::isError() should not be called statically in /home/nominatim/lib/db.php on line 8 PHP Strict Standards: Non-static method DB::isManip() should not be called statically, assuming $this from incompatible context in /usr/share/php/DB/common.php on line 2200

Strict Standards: Non-static method DB::isManip() should not be called statically, assuming $this from incompatible context in /usr/share/php/DB/common.php on line 2200

PHP Strict Standards: Non-static method DB::isManip() should not be called statically, assuming $this from incompatible context in /usr/share/php/DB/common.php on line 2200

Strict Standards: Non-static method DB::isManip() should not be called statically, assuming $this from incompatible context in /usr/share/php/DB/common.php on line 2200

PHP Warning: pg_query(): Query failed: ERROR: operator does not exist: unknown => text LINE 1: SELECT 'ref'=>NEW.postcode

    ^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: SELECT 'ref'=>NEW.postcode CONTEXT: PL/pgSQL function placex_insert() line 84 at assignment in /home/nominatim/utils/setup.php on line 455

Warning: pg_query(): Query failed: ERROR: operator does not exist: unknown => text LINE 1: SELECT 'ref'=>NEW.postcode

   ^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: SELECT 'ref'=>NEW.postcode CONTEXT: PL/pgSQL function placex_insert() line 84 at assignment in /home/nominatim/utils/setup.php on line 455 ERROR: ERROR: operator does not exist: unknown => text LINE 1: SELECT 'ref'=>NEW.postcode ^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: SELECT 'ref'=>NEW.postcode CONTEXT: PL/pgSQL function placex_insert() line 84 at assignment ERROR: operator does not exist: unknown => text LINE 1: SELECT 'ref'=>NEW.postcode ^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: SELECT 'ref'=>NEW.postcode CONTEXT: PL/pgSQL function placex_insert() line 84 at assignment

END OF LOGS

From setup.php I can see that it is breaking down somewhere in --load-data function. Earlier tasks run just fine.

I also found in nominatim/sql/functions.sql, in line 982:

NEW.name := 'ref'=>NEW.postcode;

My software (system is gentoo):

mapnik-2.1.0

postgis-2.0.2-r2

osm2pgsql version from svn sources (tried with and without --64bit-ids support compiled in, same result)

postgres-9.2

geos-3.3.3

libxml2-2.9.0-r2

pear-1.9.4

PEAR-DB-1.7.14

PEAR-MDB2_Driver_pgsql-1.5.0_beta3

php-5.4.8

What is wrong?

In nominatim sources I have made a change:

  1. Using sed: www-data -> osmuser but this shouldn't break anything.

Also in postgres, in pg_operator table I can't find '=>' operator but I didn't modify anything there. Any help?

asked 06 Mar '13, 09:59

myvupln's gravatar image

myvupln
1111
accept rate: 0%


Support for postgresql versions >= 9.2 and postgis >= 2.0 has only been recently added to Nominatim. Please try the latest development version from github.

permanent link

answered 06 Mar '13, 10:52

lonvia's gravatar image

lonvia
6.2k25789
accept rate: 40%

Hi, thanks for quick response.

I had Nominatim from git://github.com/twain47/Nominatim.git.

I used version: Nominatim-2.0.0 (from tag).

After checkout to master (so now I am using the latest commit):

ERROR: PostGIS version is not correct. Expected 1.5 found 2.0

So currently I need to switch to postgis-1.5.3 from postgis-2.0.0 :(

Thanks for Your help.

(06 Mar '13, 13:01) myvupln

As I thought. This requires also downgrade of whole postgresql-server to version 9.1.x due to postgis dependency and so on, and so on...

(06 Mar '13, 13:09) myvupln

You need to change the postgis version in your settings/local.php. Just copy the relevant line from settings/settings.php and change the version to 2.0.

(06 Mar '13, 13:10) lonvia

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×689
×219
×55
×8
×1

question asked: 06 Mar '13, 09:59

question was seen: 13,027 times

last updated: 06 Mar '13, 13:10

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum