Bug report #7828
error message on startup
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||linux||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||16712|
with latest master I get a popup message with the following error, startup continues normally after dismissing popup
Update of view in private qgis.db failed.
no such view: vw_srs
setting to GUI category, as lack of proper alternative
#1 Updated by Nathan Woodrow about 10 years ago
Is this still and issue. Can we remove the blocker tag.
#2 Updated by Etienne Tourigny about 10 years ago
I have updated to latest master and removed my .qgis2 folder, and the issue still persists. This should be a blocker, because an error msg like this should not appear on startup and should be fixed (whatever the problem is).
#3 Updated by Etienne Tourigny about 10 years ago
- Status changed from Open to Closed
actually, seems the problem dissapeared after running a second time, so I will close the bug.
#4 Updated by Etienne Tourigny about 10 years ago
- Status changed from Closed to Reopened
seems it has come back... am I the only one getting this?
#5 Updated by Etienne Tourigny about 10 years ago
the following patch resolves the issue. Somehow my qgis.db was left without the vw_srs view.
diff --git a/src/app/qgisapp.cpp b/src/app/qgisapp.cpp index 6ebb242..4b4795c 100644 --- a/src/app/qgisapp.cpp +++ b/src/app/qgisapp.cpp @@ -2160,7 +2160,7 @@ bool QgisApp::createDB() } if ( sqlite3_exec( db, - "DROP VIEW vw_srs;" + "DROP VIEW IF EXISTS vw_srs;" "CREATE VIEW vw_srs AS" " SELECT" " a.description AS description"
#6 Updated by Jürgen Fischer about 10 years ago
- Status changed from Reopened to Closed
Fixed in changeset 640f345e92985be425b05f87c19f5b4318830127.