Hi, "Name" is sometimes a reserved keyword. I don't know about MySQL, but I would have a try with escaped "name" or 'name'.
-Jukka Rahkonen- rkrojero wrote: > > Hi guys im getting an error on mapserver version 6.2.1 on ogr connection > > msDrawMap(): Image handling error. Failed to draw layer named 'govt'. > msOGRLayerInitItemInfo(): OGR error. Invalid Field name: name > > ogrinfo -ro -al > MYSQL:mapresearch,user=devuser,password=devpwd,tables=establishment -sql > 'SELECT name, longlat_x, longlat_y FROM establishment WHERE layer_type = > "BANK"' > > FAILURE: > Unable to open datasource > `MYSQL:mapresearch,user=devuser,password=devpassword,t > ables=establishment' > with the following drivers. > -> ESRI Shapefile > -> MapInfo File > -> UK .NTF > -> SDTS > -> TIGER > -> S57 > -> DGN > -> VRT > -> REC > -> Memory > -> BNA > -> CSV > -> GML > -> GPX > -> KML > -> GeoJSON > -> GMT > -> PCIDSK > -> XPlane > -> AVCBin > -> AVCE00 > -> DXF > -> Geoconcept > -> GeoRSS > -> GPSTrackMaker > -> VFK > -> PGDump > -> GPSBabel > -> SUA > -> OpenAir > -> PDS > -> WFS > -> HTF > -> AeronavFAA > -> EDIGEO > -> GFT > -> SVG > -> CouchDB > -> Idrisi > -> ARCGEN > -> SEGUKOOA > -> SEGY > > Installed apps as follows > MapServer version 6.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG > SUPPORTS=PROJ SUPPORTS=GD SUPPORTS=AGG SUPPORTS=FREETYPE > SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT > SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER > SUPPORTS=SOS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG > INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE mysql version 5.6.13 apache 2.4.6 > php 5.4.7 > > This is working on the old server > MapServer version 5.0.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG > OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE > SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER > SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL > INPUT=SHAPEFILE Php 5.2.1 MySQL 5.5.10 > Apache/2.0.55 > > I hope you can help me guys.. Thanks > > > > > -- > View this message in context: http://osgeo-org.1560.x6.nabble.com/Mysql-Ogr- > Error-tp5103949.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
