Opened 11 years ago

Closed 10 years ago

#1231 closed defect (wontfix)

Mapfish search query fails

Reported by: darkblueb Owned by: live-demo@…
Priority: normal Milestone:
Component: OSGeoLive 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, AS poi_osm_id, poi_osm.rating AS poi_osm_rating, 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 ILIKE '%%' AND poi_osm.type = 'Cafe' AND poi_osm.rating = '1'

Change history (1)

comment:1 by darkblueb, 10 years ago

Resolution: wontfix
Status: newclosed
Note: See TracTickets for help on using tickets.