[Mapserver-users] Mapserver + PostGIS for dummies.

[Jason M. Nielsen]

Quoting "Jason M. Nielsen" <jnielsen at aero-graphics.com>:

> msDrawMap(): Image handling error. Failed to draw layer named 'Utah
> Geological
> Study'.
> 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 s81
> WHERE
> the_geom && setSRID('BOX3D(1781048.9509602 472006.998403,2143367.3005688
> 833751.562963)'::BOX3D, find_srid('','s81','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. 

The fact that select works and that I have been seeing similar posts on the
postgis mailing list I am thinking this is an issue related to postgis. Perhaps
my configuration or versions. Not sure.

[root at vad3rZIM root]# postgres -V
postgres (PostgreSQL) 7.3.4

postgis-0.8.0

[root at vad3rZIM postgis]# /var/www/cgi-bin/mapserv -v
MapServer version 4.0.1 OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP SUPPORTS=PROJ
SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT INPUT=TIFF INPUT=EPPL7 INPUT=JPEG INPUT=POSTGIS INPUT=OGR
INPUT=GDAL INPUT=SHAPEFILE
[


-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/