I have a MySQL database in which there are auto generated points almost 1000 created via Laravel (PHP framework) it has a very simple schema as shown below. I just want to visualise them on an OpenStreetMap map in QGIS,
I did add a vector layer and set the source to be my points table The points do not show on the map, but when I open attributes table and then keep moving to next feature from the attributes table window the QGIS blinks red circles on the display indicating that there are points there. But unfortunately it does not render and I have been struggling for a while to get them displayed. I have attached another screen shot showing when it blinks them. I am new to QGIS.
UPDATE : After doing a lot of search and experiments with changing data inserting it manually in mysql using different variations, turns out this is an OLD QGIS Bug. There is a work around to to make it render the data but then it won't allow you to edit the data.
Here is the link, issue already reported but not yet fixed as I tested in QGIS 3.10 version
https://issues.qgis.org/issues/20563 https://github.com/qgis/QGIS/issues/28383