I am testing out a new install of PostGIS and MapServer on OS X Leopard. I
built a map file to display a simple ten point layer coming from PostGIS.
I get the following error:
msDrawMap(): Image handling error. Failed to draw layer named 'basemap'.
prepare_database(): Query error. Couldnt recover from a bad query: 'DECLARE
mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),the_geom::text from
ten_points_layer WHERE the_geom && setSRID('BOX3D(146545.5 4814000,804891.5
5472346)'::BOX3D, find_srid('','ten_points_layer','the_geom') )'
Here is the layer definition:
LAYER
NAME basemap
STATUS DEFAULT
TYPE POLYGON
CONNECTIONTYPE POSTGIS
CONNECTION "host=localhost dbname=mydb user=myuser password=mypass
port=5432"
DATA "the_geom FROM ten_points_layer using unique the_geom"
CLASS
COLOR 255 255 255
OUTLINECOLOR 181 181 181 #An OUTLINECOLOR with no COLOR gives same
effect as old POLYLINE
END
PROJECTION
"init=epsg:26915"
END
END
Any ideas? I am also having trouble getting QGIS to display the layer.
Thanks,
David.