[mapserver-dev] map is not displayed using ms4w and postgis

[sanjib chatterjee]

Hi All,
Till not working.

I like to share the debug message what I got

[

Wed May 25 11:07:18 2011,3964,127.0.0.1,Internal_plots,3,-86.313758
-25.466203 148.562665 122.433797,-1.000000 -1.000000,Internal_plots
,msDrawMap(): Image handling error. Failed to draw layer named
'Internal_plots'. <br>
msPostGISLayerWhichShapes(): Query error. Error (ERROR:  column "oid"
does not exist
LINE 1: ...ction(force_2d("the_geom")),'NDR'),'hex') as geom,"oid" from...
                                                             ^
) executing query: select
"dag_no",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex')
as geom,"oid" from "Internal_plots" where the_geom &&
GeomFromText('POLYGON((-86.3137578282636
-25.466203212721,-86.3137578282636 122.43379678728,148.562664935966
122.43379678728,148.562664935966 -25.466203212721,-86.3137578282636
-25.466203212721))',find_srid('','"Internal_plots"','the_geom')) <br>
msPostGISRetrievePgVersion(): Query error. Unable to parse version string. <br>

]


With Thanks and best regards
Sanjib

On Tue, May 24, 2011 at 5:29 PM, Jeff McKenna
<jmckenna at gatewaygeomatics.com> wrote:
> On 11-05-24 8:44 AM, sanjib chatterjee wrote:
>>
>> Hi All,
>>
>> I am using geomoose2 framework + ms4w + postgresql 9.0 and postgis 1.5.
>>
>> While my mapscript use DATA  from shape file and / or from mysql table
>> ,map is generated and displayed well.
>> but when it fetch from postgresql it fails to generate map. I am not
>> getting any error message.
>>
>> Please help to find my problem.I am new in this area. I gave bellow my
>> mapscript for shape,mysql and postgis.
>
> Hello,
>
> This seems similar to a recent question on the -users mailing list:
> http://osgeo-org.1803224.n2.nabble.com/Mapserver-6-WMS-PostGIS-Problem-td6387007.html
>
> -jeff
>
> --
> Jeff McKenna
> MapServer Consulting and Training Services
> http://www.gatewaygeomatics.com/
>
>
>
>
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>