[QGIS-Developer] Strange Mysql (spatial) behaviour: no points visible

[Nyall Dawson]

On Wed, 17 Jan 2024 at 06:15, Alessandro Pasotti via QGIS-Developer <
qgis-developer at lists.osgeo.org> wrote:

> Hi Richard,
>
> sorry, no hints except to check the logs and the QGIS dev tools query
> logger: is there anything suspicious?
>

There's a LOT of open bugs relating to mysql data -- eg
https://github.com/qgis/QGIS/issues/34170 . 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.

Perhaps something we could focus on during the upcoming 3.36 bug fix sprint?

Nyall



>
> On Tue, Jan 16, 2024 at 8:08 PM Richard Duivenvoorde via
> QGIS-Developer <qgis-developer at lists.osgeo.org> wrote:
> >
> > No hints :-) ?
> >
> > I now have a live connection to the db, and can reproduce the issue here
> in master on Linux too.
> >
> > 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
> >
> > ogrinfo shows exactly the same information of the db ( using -so).
> >
> > coordinates are fine too:
> >
> > select coord, ST_AsWKT(coord) from tblQgisProjecten tqp limit 1
> >
> > coord                                    |ST_AsWKT(coord)
>          |
> >
> -----------------------------------------+----------------------------------------+
> > POINT (168937.186906043 175180.302889316)|POINT(168937.186906043
> 175180.302889316)|
> >
> > 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.
> >
> > As I cannot share the connection info, I'm happy to share my screen or
> so to show this.
> >
> > SELECT version();
> > version()|
> > ---------+
> > 8.0.34-26|
> >
> > but is an upgraded db, not sure where it came from
> >
> > Regards,
> >
> > Richard Duivenvoorde
> >
> >
> > On 1/12/24 15:06, Richard Duivenvoorde via QGIS-Developer wrote:
> > > Hi Devs,
> > >
> > > I was contacted by a company who after upgrading their db and QGIS did
> NOT see the points anymore.
> > >
> > > Note that 'all worked' when they used QGIS 3.10 (and an older mysql db)
> > > 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.
> > >
> > > A small export loaded in my local db was OK in QGIS.
> > >
> > > So in a online meeting, sharing their screen I tried:
> > >
> > > - opening the db with ogrinfo: all data is visible (POINT(.....))
> showing correct coords and attributes
> > > - loading the table (25000 records) in QGIS: data: EPSG:31370 project
> EPSG:31370 :
> > >      - attribute table shows all records
> > >      - mapcanvas empty!
> > >      - able to 'zoom to' records (Belgium), but NO points
> visible/selectable
> > > - creating a tiny table with only id and geom column of 3 records:
> mapcanvas emtpy
> > > - export the loaded (but invisible) layer to a geopackage: points AND
> attributes VISIBLE!
> > > - loading the data in dbeaver: all data is shown in the spatial tab
> > >
> > > There was an encoding issue when exporting to gpkg, but we tried to
> create a smaller table (very few columns): nothing.
> > >
> > > Anybody familiar with QGIS and Mysql has an idea what this not showing
> of any point/geom could be?
> > >
> > > Any hint appreciated, I plan to try to get a connection to the db
> myself, but hoping I just miss something obvious...
> > >
> > > Regards,
> > >
> > > Richard Duivenvoorde
> > > _______________________________________________
> > > QGIS-Developer mailing list
> > > QGIS-Developer at lists.osgeo.org
> > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> >
> > _______________________________________________
> > QGIS-Developer mailing list
> > QGIS-Developer at lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
>
> --
> Alessandro Pasotti
> QCooperative:  www.qcooperative.net
> ItOpen:   www.itopen.it
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20240117/da4fbd45/attachment.htm>