<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Times New Roman \, serif";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Lee, OK thanks so much! Didn’t realize those were old versions on that download page. Glad to see that is all there is to it not working. I’m just a newbie who has been entrenched in ESRI software since 1995 and am finally seeing the light and learning about all these free and opensource goodies like SpatiaLite.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>David<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> Lee Hachadoorian [mailto:lee.hachadoorian@gmail.com] <b>On Behalf Of </b>Lee Hachadoorian<br><b>Sent:</b> Tuesday, November 12, 2013 3:24 AM<br><b>To:</b> Chrest, David<br><b>Cc:</b> qgis-user@lists.osgeo.org<br><b>Subject:</b> Re: [Qgis-user] QspatiaLite Plugin: need SpatiaLite installed?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>On 11/11/2013 04:50 PM, Chrest, David wrote:<br><br><o:p></o:p></p><p class=MsoNormal>I installed the new QspatiLite plugin and my test-2.3.sqlite database I downloaded from <a href="http://www.gaia-gis.it/spatialite-2.3.1/resources.html">http://www.gaia-gis.it/spatialite-2.3.1/resources.html</a> 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.<o:p></o:p></p><p class=MsoNormal>I can’t do anything with this plugin. Yet I can easily view the same spatialite database with the DB Manager plugin.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>I get this error message when I first go to use and click on the QspatiaLite plugin:<o:p></o:p></p><p class=MsoNormal>The SQL query seems to be invalid.<o:p></o:p></p><p class=MsoNormal>no such table: views_geometry_columns.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>I click OK then get this message:<o:p></o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman , serif","serif"'>This DataBase seems to be a valid SQLite DataBase but not a valid SpatiaLite One</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman , serif","serif"'>Would you like QSpatiaLite to automatically transform it to SpatiaLite (information won't be lost) ?</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman , serif","serif"'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman , serif","serif"'>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.</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman , serif","serif"'>If I choose yes, then I get this message: </span>Unable to convert Database to SpatiaLite. I click OK and the same thing happens.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Do I need to install SQLite and SpatiaLite or am I doing something wrong?<o:p></o:p></p><p class=MsoNormal>Everything works great in the DB Manager and I can view the geographic points, line, polygons just fine in QGIS.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Thanks for any help.<o:p></o:p></p><p class=MsoNormal>David<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>David,<br><br>The test DB you downloaded is for an old SpatiaLite version, and does in fact lack a views_geometry_columns table. The current version is 4.1. Although some people are still using 3.0, I don't think 2.x is very common anymore, and I doubt whether the developer would be interested in adding support for it. You should try testing with a newer SpatiaLite DB. I don't think Gaia-SINS hosts test DBs in the newer formats, but you can convert the one you downloaded with: <br><br> spatialite_convert -d test-2.3.sqlite -v 4<br><br>Although lack of a SpatiaLite install is not the cause of the problem, presumably access to the spatialite_convert utility *would* require a SpatiaLite install. After running the convert, QSpatiaLite opens the database file just fine. Note that conversion does not alter your geographic data in any way, it merely alters the supporting tables (like adding views_geometry_columns if converting from 2.x to 3 or 4, and deleting it if moving in the other direction). <br><br>More info on the conversion utility at <a href="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</a> (almost all the way to the bottom of the page).<br><br>Best,<br>--Lee<o:p></o:p></span></p></div></body></html>