QGIS » QGIS Application

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