Hi,
The Problem may be either u don't have geom. Or find out whether geom. Field is existed or not ? or you have to use SRID.Please check my map file below I have given MAP NAME Test STATUS ON SIZE 650 400 UNITS dd IMAGECOLOR 102 153 153 EXTENT 64.881 5.469 97.898 37.762 PROJECTION 'proj=longlat' 'ellps=WGS84' 'datum=WGS84' 'no_defs' '' END SYMBOL NAME "border" TYPE VECTOR POINTS 0 0 1 0 1 0.8 0 0.8 0 0 END STYLE 10 6 1 6 END FILLED TRUE END # Background color for the map canvas -- change as desired # IMAGECOLOR 192 192 192 IMAGEQUALITY 95 IMAGETYPE png OUTPUTFORMAT NAME jpeg DRIVER "GD/JPEG" MIMETYPE "image/jpeg" IMAGEMODE RGB EXTENSION "jpg" END SCALEBAR INTERVALS 2 UNITS kilometers STYLE 1 POSITION lc STATUS embed LABEL SIZE small COLOR 0 0 0 END END LAYER NAME "India" TYPE POLYGON CONNECTIONTYPE POSTGIS CONNECTION "host=localhost dbname=GIS password=administrator user=postgres port=5432" Data "the_geom from (select gid,name,pincode,district,address,website,phnumber,areaname,category,longitu de,latitude,metroname,the_geom from indiaparks) as Foo USING UNIQUE gid USING 'srid=24047'" STATUS ON TRANSPARENCY 40 MinScale 7054330 LABELITEM "cntry_name" #label Item CLASSITEM "cntry_name" TEMPLATE "query.html" CLASS NAME 'India' STYLE SYMBOL "border" SIZE 6 OUTLINECOLOR 0 0 0 COLOR 251 252 179 END LABEL #label class start POSITION auto #label Position FONT sans SIZE SMALL #lable size COLOR 0 38 237 # label color END # label end END END END END Thanks Venkat. From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of syed mohseen Sent: Monday, March 16, 2009 11:01 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] cannot able to test the mapfile-database eror hi all, i am a new bie to fgs and i want to test one of my mapfile with connecting to my database. here is my mapfile NAME "test" SIZE 800 600 IMAGECOLOR 249 245 186 IMAGETYPE png EXTENT -1.00 -1.00 1.00 1.00 LAYER CONNECTIONTYPE postgis NAME "test" CONNECTION "user=postgres password=hellopostgres dbname=postgres host=localhost" DATA "geom FROM test" STATUS ON TYPE POINT END END whenever i test the file as shp2img i get the following error msDrawMap(): Image handling error. Failed to draw layer named 'test'. <br> prepare_database(): Query error. Error executing POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(geom)),'NDR'),OID::text from test WHERE geom && setSRID('BOX3D(-1.3338898163606 -1,1.3338898163606 1)'::BOX3D, find_srid('','test','geom') )' Postgresql reports the error as 'ERROR: find_srid() - couldnt find the corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS table? Is there an uppercase/lowercase missmatch? ' 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/ Mappostgis.c - version of Jan 23/2004. <br> any solutions will be appreciated regards SyedMohseen
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users