Bug report #17537

MYSQL Connection with wrong tables

Added by Gerd Dreier over 6 years ago. Updated about 5 years ago.

Category:Data Provider
Affected QGIS version:2.18.14 Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:no timely feedback
Crashes QGIS or corrupts data:Yes Copied to github as #:25434


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 atble over the layerid is not a good idea. In former Times it was better!


#1 Updated by Giovanni Manghi about 6 years ago

  • Priority changed from Normal to High

#2 Updated by Jürgen Fischer about 5 years ago

  • Status changed from Open to Feedback

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

#3 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to no timely feedback
  • Status changed from Feedback to Closed

Also available in: Atom PDF