Bug report #17537

MYSQL Connection with wrong tables

Added by Gerd Dreier over 2 years ago. Updated over 1 year ago.

Status:Closed
Priority:High
Assignee:-
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

Description

In former times MYSQL Connection from a table as saved in the QGS File as:

<datasource>MySQL:OrkanDB,host=Server,port=3306,user=webuser,password=xxxx,tables=gewstation|layername=gewstation</datasource>

Now it is saved as:

<datasource>MySQL:OrkanDB,host=Server,port=3306,user=webuser,password=xxxx|layerid=93</datasource>

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!

History

#1 Updated by Giovanni Manghi over 2 years ago

  • Priority changed from Normal to High

#2 Updated by Jürgen Fischer over 1 year 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 over 1 year ago

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

Also available in: Atom PDF