[mapserver-users] Mysql Ogr Error

[Rahkonen Jukka (Tike)]

Hi,
Error tells now that field "pangalan" is missing. You have gone further.

- Jukka-

________________________________
Lähettäjä: rkrojero<mailto:rkrojero at gmail.com>
Lähetetty: ‎16.‎2.‎2014 15:33
Vastaanottaja: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Aihe: Re: [mapserver-users] Mysql Ogr Error



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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20140216/d0482401/attachment.htm>