regarding your suggestion on changing 'name' to something else I already Did it. Rahkonen Jukka (Tike) wrote > What did you mean with that? Mapserver reads MySQL through GDAL so you > should compile GDAL with MySQL and Mapserver with that GDAL. I am sorry if > I am lost because I do not compile anything myself. > For fixing the issue the first step is to get GDAL with MySQL support. > Before you have such all other work you do is wasting everybody's time. > > I do not believe much in my theory of reserved keyword "name" but I have > experienced something like that myself. If something works with v. 5.0 > does not guarantee that it works as such with v. 6.2. If, once you have a > proper GDAL with MySQL and Mapserver with that GDAL, you still face a > problem, I would recommend to have try escaping "name". It means 10 > seconds work for you to edit your mapfile and try. That is not much wasted > time at all even if it had no effect at all. > > -Jukka Rahkonen-
Sorry I meant the compiled Gdal has --with-mysql on it. Yep will look for a Gdal that has mysql support. I dont know where to start though. Already checked the 'name' theory I changed > <OGRVRTDataSource> > > <OGRVRTLayer name="govtpoints"> > > <SrcDataSource> > MYSQL:mapresearch,user=devuser,password=devpassword,host=127.0.0.1,port=3306,tables=establishment > </SrcDataSource> > > <SrcSQL> > SELECT esname, longlat_x, longlat_y FROM establishment WHERE esname like > "%Barangay%Hall%" AND layer_type = "GOVT" > </SrcSQL> > > <GeometryType> > wkbPoint > </GeometryType> > > <GeometryField encoding="PointFromColumns" x="longlat_x" y="longlat_y" /> > > </OGRVRTLayer> > </OGRVRTDataSource> even the .map > LAYER > NAME "govt" > STATUS OFF > CONNECTIONTYPE OGR > CONNECTION "/home/mapserv/mapresearch/ovf/govt.ovf" > DATA "govtpoints" > TYPE POINT > LABELITEM "pangalan" > LABELMAXSCALEDENOM 3500 > > CLASS > SYMBOL "/usr/local/apache2/htdocs/symbols/govt.gif" > SIZE 12 > > LABEL > COLOR 0 0 128 > TYPE TRUETYPE > FONT arial > SIZE 7 > MAXSIZE 7 > ANTIALIAS TRUE > POSITION CR > PARTIALS FALSE > MINDISTANCE 300 > BUFFER 5 > FORCE FALSE > OFFSET 5 0 > END > END > END Yea same error occured > msDrawMap(): Image handling error. Failed to draw layer named 'govt'. > msOGRLayerInitItemInfo(): OGR error. Invalid Field name: pangalan Next option is to look for a Gdal that supports mysql. Im currently reading this one.. http://mapserver.org/input/vector/mysql.html Thanks for your quick response. Will let you know how if this works. Thank you very much -karl -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Mysql-Ogr-Error-tp5103949p5104059.html Sent from the Mapserver - User mailing list archive at Nabble.com. _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users