Feature request #2588
Custom CRS sqlite3 query error
|Pull Request or Patch supplied:||Resolution:||fixed|
|Easy fix?:||No||Copied to github as #:||12648|
There is an error in the sqlite3 query that selects custom CRS from qgis.db. The query tries to get the auth_id and auth_name fields, which don't exist. It doesn't query the epsg field, which does exist. Note that the insert queries for tbl_srs don't affect any of these fields.
As a result, if you set your map canvas or layer to a custom crs it doesn't make it into the project file. Also, the dialogs don't have the correct default custom crs set when you open them.
This patch removes the auth_id & auth_name fields and puts in the epsg field. It works on Kubuntu 9.10, QGIS trunk r13139.
Alternatively, the database structure could be in error.