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+jo...@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@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user