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

[Donovan Cameron]

Thanks Andre, I found that in the midterm already =) and it works great.

I was trying to use the Layer > Create option, but I couldn't actually make
a valid layer, I could only use that to create the sqlite database. It
wouldn't let me put any layers into it.

*"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."

*This is probably because qgis uses the latest spatialite I have installed
to make the new layer in the sqlite db.

I've filed this bug to see if they can consider building a spatialite v3
package in the meantime for RPM based linux distros.
https://bugzilla.novell.com/show_bug.cgi?id=793570


On Sun, Dec 9, 2012 at 1:19 PM, Andre Joost <andre+joost at nurfuerspam.de>wrote:

> Am 09.12.2012 20:16, schrieb Alex Mandel:
>
>  The plugin requires pyspatialite but QGIS itself has the provider built
>> in.
>>
>> "SpatiaLite version ..: 4.0.0"
>>
>> Grab an older version of the Spatialite GUI (1.4 or 1.5) or figure out
>> how to convert your db to the 3.x variant (I believe the release notes
>> mention this is possible).
>>
>
> There is a spatialite_convert tool that converts 3.x databases to 4.x and
> back. See
> https://www.gaia-gis.it/**fossil/libspatialite/wiki?**
> name=switching-to-4.0<https://www.gaia-gis.it/fossil/libspatialite/wiki?name=switching-to-4.0>
>
> I usually create sqlite databases with Layer->Create new spatialite layer,
> and entering a new filename. The gui can read 3.x and 4.x databases
> wkithout problem.
>
> HTH,
> André Joost
>
>
> ______________________________**_________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/**mailman/listinfo/qgis-user<http://lists.osgeo.org/mailman/listinfo/qgis-user>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20121209/773328a9/attachment.html>