<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 17 Jan 2024 at 06:15, Alessandro Pasotti via QGIS-Developer <<a href="mailto:qgis-developer@lists.osgeo.org">qgis-developer@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Richard,<br>
<br>
sorry, no hints except to check the logs and the QGIS dev tools query<br>
logger: is there anything suspicious?<br></blockquote><div><br></div><div>There's a LOT of open bugs relating to mysql data -- eg <a href="https://github.com/qgis/QGIS/issues/34170">https://github.com/qgis/QGIS/issues/34170</a> . I suspect it's very rarely used, and there's either a bug in GDAL or some special handling which needs adding to QGIS to get this to work.</div><div><br></div><div>Perhaps something we could focus on during the upcoming 3.36 bug fix sprint?</div><div><br></div><div>Nyall</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
On Tue, Jan 16, 2024 at 8:08 PM Richard Duivenvoorde via<br>
QGIS-Developer <<a href="mailto:qgis-developer@lists.osgeo.org" target="_blank">qgis-developer@lists.osgeo.org</a>> wrote:<br>
><br>
> No hints :-) ?<br>
><br>
> I now have a live connection to the db, and can reproduce the issue here in master on Linux too.<br>
><br>
> It's really strange: have a local db, I can even copy features from the attribute table to my local table, and THEN they show up<br>
><br>
> ogrinfo shows exactly the same information of the db ( using -so).<br>
><br>
> coordinates are fine too:<br>
><br>
> select coord, ST_AsWKT(coord) from tblQgisProjecten tqp limit 1<br>
><br>
> coord |ST_AsWKT(coord) |<br>
> -----------------------------------------+----------------------------------------+<br>
> POINT (168937.186906043 175180.302889316)|POINT(168937.186906043 175180.302889316)|<br>
><br>
> could it be in char encoding, or in a strange attribute value? We already tried to create a simple view with only coord and ID, but that did not show something either.<br>
><br>
> As I cannot share the connection info, I'm happy to share my screen or so to show this.<br>
><br>
> SELECT version();<br>
> version()|<br>
> ---------+<br>
> 8.0.34-26|<br>
><br>
> but is an upgraded db, not sure where it came from<br>
><br>
> Regards,<br>
><br>
> Richard Duivenvoorde<br>
><br>
><br>
> On 1/12/24 15:06, Richard Duivenvoorde via QGIS-Developer wrote:<br>
> > Hi Devs,<br>
> ><br>
> > I was contacted by a company who after upgrading their db and QGIS did NOT see the points anymore.<br>
> ><br>
> > Note that 'all worked' when they used QGIS 3.10 (and an older mysql db)<br>
> > After a MySQL database upgrade, QGIS 3.10 was not able to connect anymore (apparently TLS issues), so they have to use 3.28 or higher.<br>
> ><br>
> > A small export loaded in my local db was OK in QGIS.<br>
> ><br>
> > So in a online meeting, sharing their screen I tried:<br>
> ><br>
> > - opening the db with ogrinfo: all data is visible (POINT(.....)) showing correct coords and attributes<br>
> > - loading the table (25000 records) in QGIS: data: EPSG:31370 project EPSG:31370 :<br>
> > - attribute table shows all records<br>
> > - mapcanvas empty!<br>
> > - able to 'zoom to' records (Belgium), but NO points visible/selectable<br>
> > - creating a tiny table with only id and geom column of 3 records: mapcanvas emtpy<br>
> > - export the loaded (but invisible) layer to a geopackage: points AND attributes VISIBLE!<br>
> > - loading the data in dbeaver: all data is shown in the spatial tab<br>
> ><br>
> > There was an encoding issue when exporting to gpkg, but we tried to create a smaller table (very few columns): nothing.<br>
> ><br>
> > Anybody familiar with QGIS and Mysql has an idea what this not showing of any point/geom could be?<br>
> ><br>
> > Any hint appreciated, I plan to try to get a connection to the db myself, but hoping I just miss something obvious...<br>
> ><br>
> > Regards,<br>
> ><br>
> > Richard Duivenvoorde<br>
> > _______________________________________________<br>
> > QGIS-Developer mailing list<br>
> > <a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
> > List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
> > Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
><br>
> _______________________________________________<br>
> QGIS-Developer mailing list<br>
> <a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
<br>
<br>
<br>
-- <br>
Alessandro Pasotti<br>
QCooperative: <a href="http://www.qcooperative.net" rel="noreferrer" target="_blank">www.qcooperative.net</a><br>
ItOpen: <a href="http://www.itopen.it" rel="noreferrer" target="_blank">www.itopen.it</a><br>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
</blockquote></div></div>