[OSM-dev] problem with mapnik

[Ruggero]

I'm trying to render a small map following these instructions:

http://wiki.openstreetmap.org/wiki/Mapnik

I did the same procedure some months ago and it worked, I was able to
create tiles. Now I've update mapnik and some osm script. I get the
message:

python generate_image.py
Traceback (most recent call last):
  File "generate_image.py", line 37, in <module>
    mapnik.load_map(m,mapfile)
RuntimeError: PSQL error:
ERROR:  syntax error at or near "from"
LINE 3:        from planet_osm_roads
               ^
Full sql was: 'select * from
      (select way,highway,ref,char_length(ref) as length,
       from planet_osm_roads
       where highway in ('motorway','trunk','primary')
         and ref is not null
      ) as roads
       limit 0'
 (encountered during parsing of layer 'planet roads text osm low zoom')


what's this? Did I forget something?

Thanks, Ruggero