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+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


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

_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to