Bug report #13732

Disabling qgis.db

Added by Mart Reinola about 5 years ago. Updated about 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:-
Affected QGIS version:2.8.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:wontfix
Crashes QGIS or corrupts data:No Copied to github as #:21759

Description

Hi all,
I have a problem with qgis.db. Every time Qgis is started, i get an error message: 'Update of view in private qgis.db failed. table vw_srs already exists'. As i understand, its because on every startup qgis application checks wheteher there is a qgis.db and whether it can update this view. Because of my user permissions it fails and i get an error message. So far i haven't found a way to disable this checking and updating. Is there a way? If not, then it would be nice to have as an option.

History

#1 Updated by Nathan Woodrow about 5 years ago

QGIS uses this database and will need write access to it. Best to fix your permissions and let the user write to the database. You need write access to the whole .qgis2 folder.

#2 Updated by Mart Reinola about 5 years ago

Thanks for the quick response.
This database is for bookmarks and custom SRS'es, right? If i dont use bookmarks and custom SRS'es, then i actually don't need this database, right? Or, at least, i don't have to check the db every time.
And for the rest of the folder, if everything is already set up by a poweruser, then there's no need for write access on the regular user level.
So, i still think it's a good idea not to check qgis.db on startup. At least as an option.

#3 Updated by Nathan Woodrow about 5 years ago

I'm not sure I see the issue with giving the user permissions to write to that database. It's expected that the user can write to anything in the .qgis2 folder as that is the point.

#4 Updated by Nyall Dawson about 5 years ago

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

Local issue... Like Nathan said, we need write access to that file. You'll need to update your permissions to match.

Also available in: Atom PDF