[Qgis-user] QspatiaLite Plugin: need SpatiaLite installed?

[Chrest, David]

I installed the new QspatiLite plugin and my test-2.3.sqlite database I
downloaded from http://www.gaia-gis.it/spatialite-2.3.1/resources.html
is listed but I cannot view anything in My Tables, Spatial Index, Sys.
Table in the Tables tree. There is not even a plus sign next to these
items to view anything.

I can't do anything with this plugin. Yet I can easily view the same
spatialite database with the DB Manager plugin.

 

I get this error message when I first go to use and click on the
QspatiaLite plugin:

The SQL query seems to be invalid.

no such table: views_geometry_columns.

 

I click OK then get this message:

This DataBase seems to be a valid SQLite DataBase but not a valid
SpatiaLite One

Would you like QSpatiaLite to automatically transform it to SpatiaLite
(information won't be lost) ?

 

If I choose No, the plugin opens and I can't do anything,
test-2.3.sqlite is listed but I cannot view any data.

If I choose yes, then I get this message: Unable to convert Database to
SpatiaLite. I click OK and the same thing happens.

 

Do I need to install SQLite and SpatiaLite or am I doing something
wrong?

Everything works great in the DB Manager and I can view the geographic
points, line, polygons just fine in QGIS.

 

Thanks for any help.

David

 

David Chrest

Research GIS Analyst

RTI International

3040 Cornwallis Rd, PO Box 12194

Research Triangle Park, NC  27709-2194

 

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