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 >> <[email protected]>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 >>> [email protected] >>> http://lists.osgeo.org/**mailman/listinfo/qgis-user<http://lists.osgeo.org/mailman/listinfo/qgis-user> >>> >>> >> >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
