<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
On 11/11/2013 04:50 PM, Chrest, David wrote:<br>
<blockquote
cite="mid:7447393869595D4EBC20745A4F48BA1F0D599F10@RTPWEXC18.RCC_NT.RTI.ORG"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
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";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@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]-->
<div class="WordSection1">
<p class="MsoNormal">I installed the new QspatiLite plugin and
my test-2.3.sqlite database I downloaded from <a
moz-do-not-send="true"
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"">This DataBase seems to be a
valid SQLite DataBase but not a valid SpatiaLite One<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif"">Would you like QSpatiaLite to
automatically transform it to SpatiaLite (information won't
be lost) ?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","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.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman","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>
</div>
</blockquote>
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 class="moz-txt-link-freetext" 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<br>
</body>
</html>