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

[Alex Mandel]

Yes, work in the master is going on to update the provider. I'm not sure
if you can backport that. Since there are likely no more releases in the
QGIS 1 series you might have to wait for QGIS 2 to get spatialite 4 support.

There's info on the qgis-dev list about this.

Thanks,
Alex

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