Hi Richard, sorry, no hints except to check the logs and the QGIS dev tools query logger: is there anything suspicious?
On Tue, Jan 16, 2024 at 8:08 PM Richard Duivenvoorde via QGIS-Developer <qgis-developer@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@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@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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
