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
