Bug report #17538
MYSQL Connection with wrong tables
|Affected QGIS version:||2.18.14||Regression?:||Yes|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||fixed/implemented|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||25435|
In former times MYSQL Connection from a table as saved in the QGS File as:
Now it is saved as:
If I add or insert a table in the database from Mysql, the layerid will be changed an QGIS connect with an other table.
To save the connection to a table over the layerid is not a good idea. In former Times it was better!
#5 Updated by Even Rouault about 2 years ago
- Resolution set to fixed/implemented
I'm pretty sure this is a known issue that has been fixed in the QGIS 3 line. Previously for multi-layer datasources, the project stored them with a layer index, which was unstable if the datasource had layers removed or added. QGIS3 now stores the layer name instead.
Closing as fixed in QGIS 3