Feature request #2588

Custom CRS sqlite3 query error

Added by sowelu - over 14 years ago. Updated over 14 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:Projection Support
Pull Request or Patch supplied: Resolution:fixed
Easy fix?:No Copied to github as #:12648

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

CustomCRSQuery_Patch.txt Magnifier (2.06 KB) sowelu -, 2010-03-24 04:09 PM

Associated revisions

Revision 5f21db70
Added by Jürgen Fischer over 14 years ago

fix #2588

git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@13155 c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision 812c5572
Added by Jürgen Fischer over 14 years ago

fix #2588

git-svn-id: http://svn.osgeo.org/qgis/trunk@13155 c8812cc2-4d05-0410-92ff-de0c093fc19c

History

#1 Updated by Jürgen Fischer over 14 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

fixed in 812c5572 (SVN r13156).

Also available in: Atom PDF