Ticket #2588 (closed patch: fixed)

Opened 3 years ago

Last modified 3 years ago

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

Attachments

CustomCRSQuery_Patch.txt Download (2.1 KB) - added by sowelu 3 years ago.

Change History

Changed 3 years ago by sowelu

Changed 3 years ago by jef

  • status changed from new to closed
  • resolution set to fixed

fixed in r13155.

Note: See TracTickets for help on using tickets.