[Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

[Donovan Cameron]

I created a sqlite/spatialite db from the spatialite_gui and started to
import a bunch of shapefiles.

Some of the things I set were the CRS to EPSG:3005 "BC Albers" and the_geom
as the name for the geometry field (type is set to auto...)

Then in spatialite_gui I expanded each new table and built a spatial index.
I can also right click each the_geom table and see a valid "Map Preview".

But I can't open or load this .sqlite files into either spatialite_gis or
qgis.
So I think this could be a problem with my actual OS (openSUSE 12.2 x64 w/
KDE).

QGIS loads the layers as tables, not vectors.
spatialite_gis thrown an error:

Missing or invalid Spatial Metadata tables:
- spatial_ref_sys
- geometry_columns

Sorry, cowardly quitting ...

But those tables are in the .sqlite db under the "Metadata" portion.

>From the layer menu in QGIS, I can't create a layer in a sqlite db. It says
that my layer is invalid and can't be created. Then I can't even see this
sqlite database (that got created successfully, it's just the layer that
failed creation) when navigating from the add vector window. But I can see
it when trying to load from spatialite_gis but that throws the same error.

I noticed in the DB Manager plugin, it says that pyspatialite is missing
and that package isn't available for openSUSE in the open build service,
unless it goes by a different name...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20121209/3e933d08/attachment.html>