[OSM-dev] Data: DB Error: no such table

2013-02-12 Thread Steven Walsh
Hello,

I'm trying to build nominatim but found this error when it as complete: Data:
DB Error: no such table


From looking around similar questions it seems that rebuilding is the only
option but I wanted to ask you if there was anything else that could be
done as I'd rather not have to wait again. The only thing maybe of interest
is that nominatim is built on a mounted data partition and I was thinking
it could just be looking in the wrong places for the database, but I've no
idea where to look.

You can see the page at maps.livemobileco.com if that helps. I hope you can
help me, thanks a million.

Steve Walsh
___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] Data: DB Error: no such table

2013-02-12 Thread Sarah Hoffmann
On Tue, Feb 12, 2013 at 11:54:16AM +, Steven Walsh wrote:
 Hello,
 
 I'm trying to build nominatim but found this error when it as complete: Data:
 DB Error: no such table
 
 
 From looking around similar questions it seems that rebuilding is the only
 option but I wanted to ask you if there was anything else that could be
 done as I'd rather not have to wait again. The only thing maybe of interest
 is that nominatim is built on a mounted data partition and I was thinking
 it could just be looking in the wrong places for the database, but I've no
 idea where to look.

It looks like the php script can find a database called 'nominatim' and can
also access it but it is somehow completely empty. Are you sure that the
import process finished successfully? Did you run any additional setup commands
after the import? If you are convinced that the import was ok, you should try 
to 
find out where your data went. Can you access the database from the command 
line (using
psql -d nominatim) and can you see the data in there? Also look out for
multiple versions of postgresql being installed in parallel.

Sarah

___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev