[Geocoding] [OpenStreetMap] #5137: Data import fails with Nominatim 2.2

[OpenStreetMap]

#5137: Data import fails with Nominatim 2.2
-----------------------+-------------------------
 Reporter:  skalinin   |      Owner:  geocoding@…
     Type:  defect     |     Status:  new
 Priority:  major      |  Milestone:
Component:  nominatim  |    Version:  2.0
 Keywords:  Germany    |
-----------------------+-------------------------
 Hi there,

 I would like to install Nominatim 2.2 with maps of Germany but fail due to
 many reasons. Following the
 instructions(http://wiki.openstreetmap.org/wiki/Nominatim/Installation)
 the first error I got was due to the encoding. The default encoding for
 PostgreSQL 9.1 is SQL_ASCII, while german maps taken from
 Geofabrik(http://download.geofabrik.de/europe/germany-latest.osm.pbf)
 requires UTF8. I have fixed that by changing ./utils/setup.php:100 to

 '' passthruCheckReturn('createdb -E UTF-8 -T template0 -p
 '.$aDSNInfo['port'].' '.$aDSNInfo['database']);''

 (e.g. using template0 instead template1 which is SQL-ASCII). After that
 data import started to work but I got post-import errors:

 ''user at mycomputer:/opt/nominatim# ./utils/setup.php --create-functions
 --enable-diff-updates[[BR]]
 Functions[[BR]]
 ...[[BR]]
 ERROR:  type wordscore[] does not exist[[BR]]
 ERROR:  type "place_boundingbox" does not exist[[BR]]
 ERROR:  type "place_boundingbox" does not exist[[BR]]
 ERROR:  type "place_boundingbox" does not exist[[BR]]
 ROW 4:   result place_boundingbox;''[[BR]]
 ...[[BR]]

 Finally, if I try to search for a city using my Firefox, I get the
 following:[[BR]]

 ''
 Internal Server Error[[BR]]
 Nominatim has encountered an internal error while processing your request.
 This is most likely because of a bug in the software.[[BR]]
 Details: Could not get word tokens.''[[BR]]

 Any help would be appreciated.

 Nominatim Version: 2.2[[BR]]
 Server: Debian Wheezy[[BR]]
 DB: PostgreSQL 9.1 with the following packages:[[BR]]
 user at mycomputer:/opt/nominatim# dpkg -l | grep postgres[[BR]]
 pi  libpostgresql-jdbc-java                  9.1-901-2[[BR]]
 ii  postgresql                               9.1+134wheezy4[[BR]]
 ii  postgresql-9.1                           9.1.12-0wheezy1[[BR]]
 ii  postgresql-9.1-postgis                   1.5.3-2[[BR]]
 ii  postgresql-client-9.1                    9.1.12-0wheezy1[[BR]]
 ii  postgresql-client-common                 134wheezy4[[BR]]
 ii  postgresql-common                        134wheezy4[[BR]]
 ii  postgresql-contrib-9.1                   9.1.12-0wheezy1[[BR]]
 ii  postgresql-server-dev-9.1                9.1.12-0wheezy1[[BR]]

 Best regards,[[BR]]
 Sergey

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