<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<div>
<div>
<div style="font-size:11pt; font-family:Calibri,sans-serif">Hi,<br>
Error tells now that field "pangalan" is missing. You have gone further.<br>
<br>
- Jukka-<br>
<br>
</div>
</div>
<div dir="ltr">
<hr>
<span style="font-size:11pt; font-family:Calibri,sans-serif; font-weight:bold">Lähettäjä:
</span><span style="font-size:11pt; font-family:Calibri,sans-serif"><a href="mailto:rkrojero@gmail.com">rkrojero</a></span><br>
<span style="font-size:11pt; font-family:Calibri,sans-serif; font-weight:bold">Lähetetty:
</span><span style="font-size:11pt; font-family:Calibri,sans-serif">16.2.2014 15:33</span><br>
<span style="font-size:11pt; font-family:Calibri,sans-serif; font-weight:bold">Vastaanottaja:
</span><span style="font-size:11pt; font-family:Calibri,sans-serif"><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a></span><br>
<span style="font-size:11pt; font-family:Calibri,sans-serif; font-weight:bold">Aihe:
</span><span style="font-size:11pt; font-family:Calibri,sans-serif">Re: [mapserver-users] Mysql Ogr Error</span><br>
<br>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText"><br>
<br>
regarding your suggestion on changing 'name' to something else I already Did<br>
it.<br>
Rahkonen Jukka (Tike) wrote<br>
> What did you mean with that? Mapserver reads MySQL through GDAL so you<br>
> should compile GDAL with MySQL and Mapserver with that GDAL. I am sorry if<br>
> I am lost because I do not compile anything myself.<br>
> For fixing the issue the first step is to get GDAL with MySQL support.<br>
> Before you have such all other work you do is wasting everybody's time.<br>
> <br>
> I do not believe much in my theory of reserved keyword "name" but I have<br>
> experienced something like that myself. If something works with v. 5.0<br>
> does not guarantee that it works as such with v. 6.2. If, once you have a<br>
> proper GDAL with MySQL and Mapserver with that GDAL, you still face a<br>
> problem, I would recommend to have try escaping "name". It means 10<br>
> seconds work for you to edit your mapfile and try. That is not much wasted<br>
> time at all even if it had no effect at all.<br>
> <br>
> -Jukka Rahkonen-<br>
<br>
Sorry I meant the compiled Gdal has --with-mysql on it. Yep will look for a<br>
Gdal that has mysql support. I dont know where to start though. <br>
<br>
Already checked the 'name' theory<br>
<br>
I changed <br>
<br>
> <OGRVRTDataSource><br>
> <br>
> <OGRVRTLayer name="govtpoints"><br>
> <br>
> <SrcDataSource><br>
> MYSQL:mapresearch,user=devuser,password=devpassword,host=127.0.0.1,port=3306,tables=establishment<br>
> </SrcDataSource><br>
> <br>
> <SrcSQL><br>
> SELECT esname, longlat_x, longlat_y FROM establishment WHERE esname like<br>
> "%Barangay%Hall%" AND layer_type = "GOVT"<br>
> </SrcSQL><br>
> <br>
> <GeometryType><br>
> wkbPoint<br>
> </GeometryType><br>
> <br>
> <GeometryField encoding="PointFromColumns" x="longlat_x" y="longlat_y" /><br>
> <br>
> </OGRVRTLayer><br>
> </OGRVRTDataSource><br>
<br>
even the .map<br>
<br>
<br>
> LAYER<br>
> NAME "govt"<br>
> STATUS OFF<br>
> CONNECTIONTYPE OGR<br>
> CONNECTION "/home/mapserv/mapresearch/ovf/govt.ovf"<br>
> DATA "govtpoints"<br>
> TYPE POINT<br>
> LABELITEM "pangalan"<br>
> LABELMAXSCALEDENOM 3500<br>
> <br>
> CLASS<br>
> SYMBOL "/usr/local/apache2/htdocs/symbols/govt.gif"<br>
> SIZE 12<br>
> <br>
> LABEL<br>
> COLOR 0 0 128<br>
> TYPE TRUETYPE<br>
> FONT arial<br>
> SIZE 7<br>
> MAXSIZE 7<br>
> ANTIALIAS TRUE<br>
> POSITION CR<br>
> PARTIALS FALSE<br>
> MINDISTANCE 300<br>
> BUFFER 5<br>
> FORCE FALSE<br>
> OFFSET 5 0<br>
> END<br>
> END<br>
> END<br>
<br>
Yea same error occured <br>
<br>
> msDrawMap(): Image handling error. Failed to draw layer named 'govt'.<br>
> msOGRLayerInitItemInfo(): OGR error. Invalid Field name: pangalan <br>
<br>
Next option is to look for a Gdal that supports mysql. <br>
<br>
Im currently reading this one.. <br>
<a href="http://mapserver.org/input/vector/mysql.html">http://mapserver.org/input/vector/mysql.html</a><br>
<br>
Thanks for your quick response. Will let you know how if this works. Thank<br>
you very much<br>
<br>
-karl<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Mysql-Ogr-Error-tp5103949p5104059.html">
http://osgeo-org.1560.x6.nabble.com/Mysql-Ogr-Error-tp5103949p5104059.html</a><br>
Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapserver-users mailing list<br>
mapserver-users@lists.osgeo.org<br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div>
</span></font>
</body>
</html>