Salve,
Sto provando a creare un db spatialite, ma il plugin qspatialite mi da i seguenti errori:
1°)
The SQL query seems to be invalid.
no such table: geometry_columns
2°)
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) ?
A questo punto se dico SI’ mi da:
Errore durante l’esecuzione di codice Python:
Traceback (most recent call last):
File “/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/qspatialite.py”, line 68, in run
dlg = QspatiaLiteApp(self.iface)
File “/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py”, line 80, in init
self.changeDb(max(0,self.connections[‘idx’]))
File “/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py”, line 146, in changeDb
self.drawTreeView()
File “/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py”, line 151, in drawTreeView
model=self.db.createTreeModel()
File “/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/Classes/Database.py”, line 98, in createTreeModel
self.getTables()
File “/autofs/nethomes/aspisni/.qgis//python/plugins/QspatiaLite/Classes/Database.py”, line 79, in getTables
if d[0][0]==1:
IndexError: list index out of range
Versione Python:
2.7.3 (default, Jul 24 2012, 11:41:40)
[GCC 4.6.3 20120306 (Red Hat 4.6.3-2)]
Versione di QGIS:
1.8.0-Lisboa Lisboa, exported
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’]
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
The SQL query seems to be invalid.
no such function: RecoverGeometryColumn
The SQL query seems to be invalid.
no such function: GeomFromText
OS:fedora16 64bits
Ciao a tutti
···
--
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
[aspisni@arpa.emr.it](mailto:aspisni@arpa.emr.it)
[http://www.arpa.emr.it/sim/?telerilevamento](http://www.arpa.emr.it/sim/?telerilevamento)