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

[Angelos Tzotsos]

Hi Donovan,

Yes, we upgraded spatialite to 4.0 a few days ago.
I will talk with other maintainers on how to solve this issue. Having 2 
versions of spatialite will probably make things worse, since many 
libraries compile against it. We would need to make a selection I am afraid.
I am wondering if there is a patch solving this issue or if this is 
solved in git master.

Any ideas?

Angelos

On 12/09/2012 10:28 PM, Donovan Cameron wrote:
> 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>
>>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user


-- 
Angelos Tzotsos
Remote Sensing Laboratory
National Technical University of Athens
http://users.ntua.gr/tzotsos

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20121209/b0fb6119/attachment.html>