id,summary,reporter,owner,description,type,status,priority,milestone,component,resolution,keywords,cc 1231,Mapfish search query fails,darkblueb,live-demo@…,"Using Mapfish on the Live 7.0 RC2.. Geospatial -> Browser Clients -> Mapfish -> Mapfish Start on the page that shows, at the bottom, click on the link to admin, then click on the link to POI. Click the Search button. Choose type -> cafe and rating -> 1 Postgres logs shows this: {{{ 2013-08-25 13:30:09 PDT ERROR: 42703: column poi_osm.the_geom does not exist at character 20 2013-08-25 13:30:09 PDT LOCATION: transformColumnRef, parse_expr.c:761 2013-08-25 13:30:09 PDT STATEMENT: SELECT ST_AsBinary(poi_osm.the_geom) AS poi_osm_the_geom, poi_osm.gid AS poi_osm_gid, poi_osm.id AS poi_osm_id, poi_osm.rating AS poi_osm_rating, poi_osm.name AS poi_osm_name, poi_osm.code_dept AS poi_osm_code_dept, poi_osm.type_desc AS poi_osm_type_desc, poi_osm.type AS poi_osm_type, poi_osm.theme AS poi_osm_theme, poi_osm.geom AS poi_osm_geom FROM poi_osm WHERE poi_osm.name ILIKE '%%' AND poi_osm.type = 'Cafe' AND poi_osm.rating = '1' }}}",defect,closed,normal,,OSGeoLive,wontfix,mapfish,