[mapserver-users] Mysql Ogr Error

[Rahkonen Jukka (Tike)]

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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users