Bug report #12868

Sqlite error - no other details "Unexpected error when working with"

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

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

Description

i converted a 2 GB osm.pbf file into a sqlite file

during the conversion, i got this errors

C:\\Users\\florinb\\Downloads>ogr2ogr -f SQlite canada.sqlite canada-latest.osm.pbf
Warning 1: organizePolygons() received an unexpected geometry.
Either a polygon with interior rings, or a polygon with less than 4 points,
or a non-Polygon geometry.  Return arguments as a collection.
Warning 1: organizePolygons() received an unexpected geometry.
Either a polygon with interior rings, or a polygon with less than 4 points,
or a non-Polygon geometry.  Return arguments as a collection.
Warning 1: organizePolygons() received an unexpected geometry.
Either a polygon with interior rings, or a polygon with less than 4 points,
or a non-Polygon geometry.  Return arguments as a collection.
Warning 1: organizePolygons() received an unexpected geometry.
Either a polygon with interior rings, or a polygon with less than 4 points,
or a non-Polygon geometry.  Return arguments as a collection.
Warning 1: organizePolygons() received an unexpected geometry.
Either a polygon with interior rings, or a polygon with less than 4 points,
or a non-Polygon geometry.  Return arguments as a collection.
Warning 1: organizePolygons() received an unexpected geometry.
Either a polygon with interior rings, or a polygon with less than 4 points,
or a non-Polygon geometry.  Return arguments as a collection.

And when i try to open the file in QGIS, i simply get :

Unexpected error when working with: C:/Users/florinb/Downloads/canada.sqlite

I would like to fix, try to do something more, but QGIS message is just to generic for any practical use and hope of making the user discover what we or she could do to fix the error

History

#1 Updated by Jürgen Fischer over 5 years ago

  • Resolution set to invalid
  • Status changed from Open to Closed
  • Subject changed from Sqlite error - no other detalils " Unexpected error when working with " to Sqlite error - no other details "Unexpected error when working with"

OGR's SQLite driver by default doesn't create a spatialite database. You can access the sqlite database via Add vector layer.... If you want to use the spatialite provider you have to invoke ogr2ogr with the additional option -dsco SPATIALITE=YES.

Also available in: Atom PDF