[Mapserver-users] PostGIS blank error - bit of a newbie question....!

[Matt Hatcher]

Hi Jan,
That's the way I've always done it. Seems to work ok if you specify the
layer name in the 'layers=' part of the URL! Maybe I've missed something
all this time.... ;-)

Matt.

>
>
> Hi Matt, why do you have "STATUS OFF"? If you want to see something, you
> have to set "STATUS DEFAULT" (or "STATUS ON" with the layer's name given
> in the url). Apart from that, your setup looks OK.
>
> Jan
>
> Matt Hatcher wrote:
>
>> Hi,
>>
>> I'm trying to get a postgres connection working with Mapserver 4.0.1 on
>> Mandrake 9.2. I'm using the Postgres and Postgis RPMs from the postgis
>> site, and the stable 4.0.1 source compiled with the postgis option. My
>> -v
>> gives:
>>
>> MapServer version 4.0.1 OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF
>> SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
>> SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT INPUT=JPEG INPUT=POSTGIS
>> INPUT=OGR
>> INPUT=GDAL INPUT=SHAPEFILE
>>
>>
>> I've got a table that I loaded from a point shapefile using shp2pgsql
>> which I can query quite happily from the psql command line. The data in
>> there is in SRID 4326, e.g.:
>>
>>  gid | id |     x     |     y     | height_m |  height_ft  | type  |
>> name    |               the_geom
>> -----+----+-----------+-----------+----------+-------------+-------+-----------+--------------------------------------
>>     |  1 | -5.003492 | 56.796264 | 1343.798 | 4408.786096 | Munro | Ben
>> Nevis | SRID=4326;POINT(-5.003492 56.796264)
>>
>>
>> When I try and get the data through Mapserver I get the following
>> unhelpful "blank" error message:
>>
>> msDrawMap(): Image handling error. Failed to draw layer named 'peaks'.
>> prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual
>> query)
>> statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
>> asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
>> mountains WHERE the_geom && setSRID('BOX3D(-10.5612147941099
>> 48.9367546675052,6.81724902590237 55.7611851275149)'::BOX3D,
>> find_srid('','mountains','the_geom') )'
>>
>> Postgresql reports the error ''
>>
>> More Help:
>>
>> Error with POSTGIS data variable. You specified '<check your .map
>> file>'.
>> Standard ways of specifiying are :
>> (1) 'geometry_column from geometry_table'
>> (2) 'geometry_column from (<sub query>) as foo using unique <column
>> name>
>> using SRID=<srid#>'
>>
>> Make sure you put in the 'using unique <column name>' and 'using SRID=#'
>> clauses in.
>>
>> For more help, please see
>> http://postgis.refractions.net/documentation.php
>>
>>
>> Mappostgis.c - version of June 12/2003.
>>
>>
>> My map file has:
>>
>> LAYER
>>   NAME "peaks"
>>   TYPE POINT
>>   STATUS OFF
>>   CONNECTIONTYPE POSTGIS
>>   CONNECTION "user=apache dbname=geo"
>>   DATA "the_geom from mountains"
>>
>>   PROJECTION
>>     "init=epsg:4326"
>>   END
>>
>>   CLASS
>>     SYMBOL 'circle'
>>     SIZE 4
>>     COLOR   0
>>   END
>> END
>>
>>
>> Any suggestions would be gratefully received!
>>
>> Cheers, Matt.
>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>