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

[sanjib chatterjee]

Hi All,
Problem is solved.
I have changed

DATA 'the_geom from (select setsrid(the_geom,1) as the_geom,
oid,dag_no from "Internal_plots") as data using unique oid using
srid=1'



Ref::
http://www.osgeo.org/pipermail/mapserver-users/2005-August/009987.html

Thank you all.

With Thanks and best regards
Sanjib chatterjee

On Wed, May 25, 2011 at 11:11 AM, sanjib chatterjee
<sanjibchatterjeegis at gmail.com> wrote:
> 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
>>
>