Bug report #8290

DB Manager does not recognize Spatialite ver. 4 metadata tables

Added by rcline - about 6 years ago. Updated about 6 years ago.

Status:Closed
Priority:Severe/Regression
Assignee:-
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

Description

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.
http://lists.osgeo.org/pipermail/qgis-developer/2013-May/026240.html

Associated revisions

Revision 558fe92e
Added by Jürgen Fischer about 6 years ago

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

History

#1 Updated by Jürgen Fischer about 6 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF