[Qgis-user] MySQL Layer do not draw with Valmiera/Ubuntugis, but works with Valmiera/Windows

[Richard Duivenvoorde]

Hi Marco,

never tried to mix mysql with QGIS. So now I tried it here on Debian.

with me QGIS master crashes (on Debian Testing), but QGIS-2.2 is doing fine.

I'll create an issue for the crash. You could for your problem do the
same if somebody else can confirm.

Regards,

Richard Duivenvoorde


On 18-06-14 13:13, Marco Manfredini wrote:
> I've hit into a problem with MySQL Layers when using QGIS-Valmiera from
> the ubuntugis-stable ppa. Step to reproduce it on my machine:
> 
> Take any dataset, like this (free, in ESRI Shape Format):
> 
> www.naturalearthdata.com/download/110m/cultural/ne_110m_admin_0_countries.zip
> 
> 
> Import to MySQL:
> 
> $ ogr2ogr -f MySQL
> MySQL:test,host=192.168.12.34,user=testuser,password=testpassword
> ne_110m_admin_0_countries.shp  -update -overwrite -lco ENGINE=MyISAM
> 
> Now I can easily open the resulting layer as a database vector layer,
> when I'm using the stand-alone QGIS Valmiera for Windows fetched from
> the official QGIS Site (Windows 7/amd64).
> 
> But - When I'm on Ubuntu 12.04, then QGIS Valmiea from the
> ubuntugis-stable ppa does this:
> 
> I add the layer from mysql - nothing is drawn to the map. The attribute
> table is populated with correct values. Zooming to the layer's extend
> gives me correct values.
> 
> The invisible layer can be exported using Layer|Save As.. (for example
> as GeoJSON)
> 
> The GeoJSON can be added again to the map and the GeoJSON layer displays
> correctly.
> 
> When I turn the the GeoJSON layer off now, then (in half of the cases)
> the MySQL layer suddenly draws correctly and keeps drawing as expected
> until I terminate the program. However, when I save the map and load it
> into a new QGIS session, then the MySQL layer is dead again.
> 
> Any ideas? This is a bit frustrating.
> 
> - Marco
> 
> $ uname -a
> Linux oblomow 3.8.0-42-generic #62~precise1-Ubuntu SMP Wed Jun 4
> 22:04:18 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
> 
> Stuff from "Help|About":
> 
> QGIS-Version    2.2.0-Valmiera    QGIS-Codeversion    exported
> Kompiliert gegen Qt    4.8.1    Laufendes Qt    4.8.2
> Kompiliert mit GDAL/OGR    1.10.0    Läuft mit GDAL/OGR    1.10.0
> Kompiliert mit GEOS    3.3.8-CAPI-1.7.8    Läuft mit GEOS   
> 3.3.8-CAPI-1.7.8
> PostgreSQL-Client-Version    9.1.11    SpatiaLite-Version    4.1.0
> QWT-Version    5.2.2    PROJ.4-Version    480
> QScintilla2-Version
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user