<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<meta name="qrichtext" content="1">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><!--StartFragment-->Salve,</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span
style=" color:#ff0000;"><font color="#000000">Sto provando a
creare un db spatialite, ma il plugin qspatialite mi da i
seguenti errori:</font></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<meta name="qrichtext" content="1">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-15">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>1°)
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><!--StartFragment--><i>The
SQL query seems to be invalid.</i><i><br>
</i></p>
<i>no such table: geometry_columns</i>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<meta name="qrichtext" content="1">
</p>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-15">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>2°)
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><!--StartFragment--><i>This
DataBase seems to be a valid SQLite DataBase but not a valid
SpatiaLite One</i></p>
<i>Would you like QSpatiaLite to automatically transform it to
SpatiaLite (information won't be lost) ?</i><br>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;">A questo
punto se dico SI' mi da:<br>
<br>
<!--EndFragment--></p>
<!--EndFragment--></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><i><span
style=" color:#ff0000;">Errore durante l'esecuzione di codice
Python:</span></i><i><br>
</i><i><br>
</i><i>Traceback (most recent call last):</i><i><br>
</i><i> File
"/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/qspatialite.py",
line 68, in run</i><i><br>
</i><i> dlg = QspatiaLiteApp(self.iface)</i><i><br>
</i><i> File
"/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py",
line 80, in __init__</i><i><br>
</i><i> self.changeDb(max(0,self.connections['idx']))</i><i><br>
</i><i> File
"/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py",
line 146, in changeDb</i><i><br>
</i><i> self.drawTreeView()</i><i><br>
</i><i> File
"/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py",
line 151, in drawTreeView</i><i><br>
</i><i> model=self.db.createTreeModel()</i><i><br>
</i><i> File
"/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/Classes/Database.py",
line 98, in createTreeModel</i><i><br>
</i><i> self.getTables()</i><i><br>
</i><i> File
"/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/Classes/Database.py",
line 79, in getTables</i><i><br>
</i><i> if d[0][0]==1:</i><i><br>
</i><i>IndexError: list index out of range</i><i><br>
</i><i><br>
</i><i>Versione Python:</i><i><br>
</i><i>2.7.3 (default, Jul 24 2012, 11:41:40) </i><i><br>
</i><i>[GCC 4.6.3 20120306 (Red Hat 4.6.3-2)]</i><i><br>
</i><i><br>
</i><i><br>
</i><i>Versione di QGIS:</i><i><br>
</i><i>1.8.0-Lisboa Lisboa, exported</i><i><br>
</i><i><br>
</i><i>Percorso Python:
['/autofs/nethomes/aspisni/.qgis/python/plugins/elevation',
'/autofs/nethomes/aspisni/.qgis//python/plugins/sextante_taudem',
'/autofs/nethomes/aspisni/.qgis//python/plugins/sextante',
'/usr/share/qgis/python',
'/autofs/nethomes/aspisni/.qgis//python',
'/autofs/nethomes/aspisni/.qgis//python/plugins',
'/usr/share/qgis/python/plugins', '/usr/lib64/python27.zip',
'/usr/lib64/python2.7', '/usr/lib64/python2.7/plat-linux2',
'/usr/lib64/python2.7/lib-tk', '/usr/lib64/python2.7/lib-old',
'/usr/lib64/python2.7/lib-dynload',
'/usr/lib64/python2.7/site-packages',
'/usr/lib64/python2.7/site-packages/PIL',
'/usr/lib64/python2.7/site-packages/geos',
'/usr/lib64/python2.7/site-packages/gst-0.10',
'/usr/lib64/python2.7/site-packages/gtk-2.0',
'/usr/lib64/python2.7/site-packages/wx-2.8-gtk2-unicode',
'/usr/lib/python2.7/site-packages',
'/usr/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg-info',
'/autofs/nethomes/aspisni/.qgis/python/plugins/openlayersov/logic',
'/autofs/nethomes/aspisni/.qgis/python/plugins/openlayersov/gui',
'/usr/share/qgis/python/plugins/fTools/tools']</i><br>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br>
se rispondo NO, mi apre il db. Se provo a caricare un file tramite
OGR o importanto da TOIC qgis mi da errore e si blocca tutto<br>
<meta name="qrichtext" content="1">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-15">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><!--StartFragment--><i>The
SQL query seems to be invalid.</i></p>
<i>no such function: RecoverGeometryColumn
</i>
<meta name="qrichtext" content="1">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-15">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><!--StartFragment--><i>The
SQL query seems to be invalid.</i></p>
<i>no such function: GeomFromText</i><br>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br>
OS:fedora16 64bits<br>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br>
Ciao a tutti<br>
<!--EndFragment--></p>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-15">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<pre class="moz-signature" cols="72">--
Andrea Spisni
Area Agrometeorologia, Territorio e Clima
Servizio IdroMeteoClima
Agenzia Regionale Prevenzione e Ambiente dell'Emilia-Romagna
V.le Silvani, 6 - 40122 Bologna Italia
Tel. +39 051 649 75 61
Fax. +39 051 649 75 01
<a class="moz-txt-link-abbreviated" href="mailto:aspisni@arpa.emr.it">aspisni@arpa.emr.it</a>
<a class="moz-txt-link-freetext" href="http://www.arpa.emr.it/sim/?telerilevamento">http://www.arpa.emr.it/sim/?telerilevamento</a></pre>
</body>
</html>