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 |
| Component: | Projection Support | Version: | Trunk |
| Keywords: | Cc: | ||
| Platform Version: | Kubuntu 9.10 | Platform: | Debian |
| Must Fix for Release: | Yes | Awaiting user input: | no |
Description
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.
Cheers,
Roland
