Bug report #8290

DB Manager does not recognize Spatialite ver. 4 metadata tables

Added by rcline - over 10 years ago. Updated over 10 years ago.

Category:DB Manager
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:17088


Using OS X 10.8.3 with latest nightly build from Dakota Cartographic. This is built with SpatiaLite version 4.

With SpatiaLite version 4 table, the tree shows the geometry field as tabular data, the info tab does not show geometry information and preview does not work. If the same database is converted to SpatiaLite ver. 3 using spatialite_convert, then this all works as expected. Drag and drop of a table with geometry into a version 4 database fails to properly create the geometry column (blank field name) and no geometry information in the metadata. Drag and drop to a SpatiaLite ver. 3 databases now works thanks to Juergen's fix cafc36 yesterday.

Sandro Furieri discussed a fix to this issue in a May 22 email to the developer list, but it has never been implemented.

Associated revisions

Revision 558fe92e
Added by Jürgen Fischer over 10 years ago

dbmanager: adapt to sl4 metadata tables (fixes #8290)


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

  • Status changed from Open to Closed

Also available in: Atom PDF