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.

Reply via email to