Vizzuality/cartodb — Issue #399: Maps API response using old query parameters
Author: andrewxhill
Created: 2011-12-20 16:35:10+00:00
State: open

The tiler appears to be looking for a column ("level") that I'm no longer asking for.

{
stack: "Error: :
ERROR: column "level" does not exist
LINE 1: ...CT AsBinary("the_geom_webmercator") AS geom,"cnt","level" fr...
^
Full sql was: 'SELECT AsBinary("the_geom_webmercator") AS geom,"cnt","level" from (SELECT cnt, ST_Transform(ST_Envelope(ST_Union(the_geom, GEOMETRYFROMTEXT('POINT('||st_xmax(the_geom)||' '||st_ymax(the_geom)||')',4326))),3857) as the_geom_webmercator FROM (SELECT count(*) as cnt, ST_SnapToGrid(the_geom, 0, 0, 4, 4) as the_geom FROM points_na GROUP By ST_SnapToGrid(the_geom, 0, 0, 4, 4)) points_na) as cdbq WHERE "the_geom_webmercator" && SetSRID('BOX3D(-10644926.30710679 1878516.40713649,-6887893.4928338 5635549.221409476)'::box3d, 3857)'
",
message: ":
ERROR: column "level" does not exist
LINE 1: ...CT AsBinary("the_geom_webmercator") AS geom,"cnt","level" fr...
^
Full sql was: 'SELECT AsBinary("the_geom_webmercator") AS geom,"cnt","level" from (SELECT cnt, ST_Transform(ST_Envelope(ST_Union(the_geom, GEOMETRYFROMTEXT('POINT('||st_xmax(the_geom)||' '||st_ymax(the_geom)||')',4326))),3857) as the_geom_webmercator FROM (SELECT count(*) as cnt, ST_SnapToGrid(the_geom, 0, 0, 4, 4) as the_geom FROM points_na GROUP By ST_SnapToGrid(the_geom, 0, 0, 4, 4)) points_na) as cdbq WHERE "the_geom_webmercator" && SetSRID('BOX3D(-10644926.30710679 1878516.40713649,-6887893.4928338 5635549.221409476)'::box3d, 3857)'
"
}