[mapserver-users] Mysql Ogr Error

[rkrojero]

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.