[Live-demo] [OSGeo] #1231: Mapfish search query fails

[OSGeo]

#1231: Mapfish search query fails
-----------------------+----------------------------------------------------
 Reporter:  darkblueb  |       Owner:  live-demo@…              
     Type:  defect     |      Status:  new                      
 Priority:  normal     |   Milestone:                           
Component:  LiveDVD    |    Keywords:  mapfish                  
-----------------------+----------------------------------------------------
 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'
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/1231>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.