search

MapQuest / MapQuest-Mapnik-Style

MapQuest Branded style for use with Mapnik and OSM
open.mapquest.co.uk
93 stars 25 forks source link

Integer Issue in layer-text.xml.inc #25

Open agponte opened 8 years ago

agponte commented 8 years ago

I get the following error by renderd. I have found this in mapquest_inc/layer-text.xml.inc but don't know how to fix it.

Anyone know how to fix the issue?

Postgis Plugin: ERROR: invalid input syntax for integer: "A1"#012#012in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,replace(replace(name,'(',''),')','') as name,ref#012 from planet_osm_point#012 where place in ('continent','country','county','state')#012 or (place in ('city','metropolis') and capital='yes' #012 and (admin_level is null or admin_level::integer < 4))#012 ) as placenames WHERE "way" && ST_SetSRID('BOX3D(-1252344.271424999 -1252344.271424999,11271098.442825 11271098.442825)'::box3d, 900913)'

tjwebb commented 8 years ago

I fixed this by removing the int cast admin_level::integer and using the IN operator. This is what the OSM styles do.