Ticket #2588 (closed patch: fixed)
Custom CRS sqlite3 query error
|Reported by:||sowelu||Owned by:||nobody|
|Priority:||major: does not work as expected||Milestone:||Version 1.5.0|
|Platform Version:||Kubuntu 9.10||Platform:||Debian|
|Must Fix for Release:||Yes||Awaiting user input:||no|
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.