[mapserver-users] newbie: Error in first atttempt to use postgis with mapserver?

[vikram_vap]

Hello,

        I have same problem as Saka. I was not able to get mapfile and
positgis working together. I am getting empty page when I am trying to
render map file containing SQL query to  postgis.  

        Saka it will be great if you can share your experience personally.
Thanks everyone.

Vikram

Saka Royban wrote:
> 
>  
> Hi everyone.
> i've used workshop material of FOSS4G2007 (PostGIS workshop)to learn
> postgis along with its data. but there is a problem
> i got this error in first attempt to retrieve data from postgis:
> 
> msDrawMap():
> Image handling error. Failed to draw layer named 'bc_municipality'.
> prepare_database(): Query error. Error declaring cursor: ERROR: column
> "oid" does not exist LINE 1:
> ...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... ^
> With query string:
> DECLARE mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
> bc_municipality WHERE the_geom && setSRID('BOX3D(458426.1
> 260651.497368421,1943216.4
> 1373313.90263158)'::BOX3D, find_srid('','bc_municipality ','the_geom')
> ) msPOSTGISLayerRetrievePGVersion(): Query error. Error executing
> POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select
> substring(version() from 12 for (position('on' in version()) - 13)) 
> 
> i don't know what causes the problem although it sounds easy.
> THX
> 
> 
> 
> 
> -----Inline Attachment Follows-----
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
>       
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/newbie%3A-Error-in-first-atttempt-to-use-postgis-with-mapserver--tp2161688p2323496.html
Sent from the Mapserver - User mailing list archive at Nabble.com.