Bug report #13238

Offline Editing Plugin not working with a postgis layer

Added by baditaflorin - over 5 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:C++ plugins/Offline editing
Affected QGIS version:2.10.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:21299

Description

When i try to convert a postgis layer to a offline project, i get this error

Offline Editing Plugin: Could not create a new database unable to open database file

History

#1 Updated by Saber Razmjooei over 5 years ago

  • Status changed from Open to Feedback
  • Category set to C++ plugins/Offline editing

Make sure user can write to the path you have selected to write your offline db.

#2 Updated by baditaflorin - over 5 years ago

  • Status changed from Feedback to Closed

Yes, that was the error.

But this is a problem for over a year, the default path in may default locations are cousin a error in QGIS
Like for example for this the location is :

C:/PROGRA~1/QGISPI~1/bin/offline.sqlite

Can we make the default location more open, to be in a folder where a user could write by default.

If not, this means a lot of clicks, making a user spend useless time.

Now it`s working, even if i got a warning.

Offline Editing Plugin: ERROR: 28 feature(s) not added. Provider errors: SQLite error: boundary_files_top25_areas20150819194023844.Geometry violates Geometry constraint [geom-type or SRID not allowed] SQL: INSERT INTO "boundary_files_top25_areas20150819194023844"("geometry","PCUID","PCPUID","PCNAME","PCTYPE","PCCLASS","CMAUID","CMAPUID","CMANAME","CMATYPE","PRUID","PRNAME") VALUES (GeomFromWKB(?, 3857),?,?,?,?,?,?,?,?,?,?,?)

Also available in: Atom PDF