Bug report #12868
Sqlite error - no other details "Unexpected error when working with"
| 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 9 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.