[postgis-users] Problem displaying postgis data with maapserver

[Ethan Alpert]

Have you tried upgrading to a current version of mapserver? June 2003 is
like ancient.

-e

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Shaq
Gbadebo
Sent: Wednesday, March 09, 2005 11:36 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Problem displaying postgis data with maapserver


Hi!

I have sorted out an initial problem, which was my postgresql server was
not 
not set for tcp/ip connections. But now here is the error I am getting.

msDrawMap(): Image handling error. Failed to draw layer named 'test'.
prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual
query) 
statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d()),'NDR'),OID::text from HBHB
WHERE 
&& setSRID('BOX3D(-1333332 -999999,1333332 999999)'::BOX3D, 
find_srid('','HBHB','') )'

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.
msPOSTGISLayerParseData(): Query error. Error parsing POSTGIS data
variable. 
Must contain 'geometry_column from table_name' or 'geom from (subselect)
as 
foo' (couldnt find ' from '). More help:

Error with POSTGIS data variable. You specified 'geom FROM test'.
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.

Any sort of help would be appreciated.

Thanks

Shaq.


_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users