Opened 6 years ago

Closed 6 years ago

#1231 closed defect (wontfix)

Mapfish search query fails

Reported by: darkblueb Owned by: live-demo@…
Priority: normal Milestone:
Component: OSGeoLive Keywords: mapfish
Cc:

Description

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'

Change history (1)

comment:1 Changed 6 years ago by darkblueb

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