[QGIS-trac] [Quantum GIS] #2588: Custom CRS sqlite3 query error

[Quantum GIS]

#2588: Custom CRS sqlite3 query error
------------------------------------------------+---------------------------
   Reporter:  sowelu                            |              Owner:  nobody       
       Type:  patch                             |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.5.0
  Component:  Projection Support                |            Version:  HEAD         
   Keywords:                                    |   Platform_version:  Kubuntu 9.10 
   Platform:  Debian                            |           Must_fix:  Yes          
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 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

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2588>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats