Bug report #17537
MYSQL Connection with wrong tables
| 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 6 years ago
- Priority changed from Normal to High
#2
Updated by Jürgen Fischer almost 6 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 over 5 years ago
- Resolution set to no timely feedback
- Status changed from Feedback to Closed