nakijun / qspatialite Goto Github PK

What steps will reproduce the problem?
1. Use the [Export Tables to txt] button in Qspatialite
2. Select any user loaded non-spatial table (do not select a spatial table) to 
export as either csv dbf or sqlite output 
3. an [Operation Done] dialog pops up: click [ok] to that

What is the expected output?  Either a csv, dbf or sqlite, depending on the 
user option selected.

What do you see instead?
NO OUTPUT IS GENERATED AT ALL

What version of the product are you using? On what operating system?
QGIS 1.8.0 with Qspatilite 6.0.5

Please provide any additional information below.

Note:  the [Export Tables to txt] button will export a spatial table to a 
non-spatial table, either csv, dbf or sqlite, depending on the user option, but 
will not export a user loaded non-spatial table.  The button [Export Spatial 
Tables to OGR Format] works to export spatial tables to output OGR shapefiles

And note, in addition to failing to export non-spatial tables, there is no also 
option to export to txt (tab separated) , as the button indicates.

What steps will reproduce the problem?
1.open Qgis 
2.open qSpatialLite
3.open/create new database

What is the expected output? What do you see instead?
expected : full sys. Table
seen : "no such table: views_geometry_columns"
Tehn : "This DataBase seems to be a valid db DataBase but not a valid 
SpatiaLite One
Would you like QSpatiaLite to automatically transform it to SpatiaLite 
(information won't be lost) ?"

What version of the product are you using? On what operating system?
Qgis 1.8 ; QspatiaLite 6.0.6 ; WIN 7 Pro 64

Please provide any additional information below.
Impossible de creer la table initiale sys.
J'ai essayé d'ajouter une couche à une base existante qui avait le sys table 
remplie : echec, table vide après un message "no such function : CastToMulti".
J'ai transformé les couches multipoint en point : même résultat.
S'il s'agit de deux problemes differents (creation/import), alors desolé pour 
l'amalgame.

quelque soit la méthode utilisée : 

1. via qgis, import d'un csv, puis import de ce csv via qspatialite
2. ou directement via qspatialite.

code d'erreur (1er type)
-----------------------


Traceback (most recent call last):
  File "C:/Users/jean-philippe.gallar/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 1442, in upload_qgis_layers
    SQL,params=self.saveLayer(layer, name, charset, srid, selected,False)
  File "C:/Users/jean-philippe.gallar/.qgis/python/plugins\QspatiaLite\qspatialite.py", line 156, in save_layer
    geometry=geom[vlayer.geometryType()]
IndexError: list index out of range

Version de Python :
2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)]


Version de QGIS :
1.7.0-Wroclaw Wroclaw, 63ecdd7

Chemin vers Python : 
['C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\GeoCoding', 
'C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\GeoCoding', 
'C:/PROGRA~1/QUANTU~1/apps/qgis/./python', 
'C:/Users/jean-philippe.gallar/.qgis/python', 
'C:/Users/jean-philippe.gallar/.qgis/python/plugins', 
'C:/PROGRA~1/QUANTU~1/apps/qgis/./python/plugins', 
'C:\\PROGRA~1\\QUANTU~1\\bin\\python25.zip', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\DLLs', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\plat-win', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\lib-tk', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\qgis\\bin', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\win32', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\win32\\lib', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\Pythonwin', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\wx-2.8-msw-unicode'
, 'C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\fTools\\tools', 
'Z:/Am\xc3\xa9nagement urbain/0--Projets et \xc3\xa9tudes en cours--0/Plans 
pour le Service D.P/Signal\xc3\xa9tique verticale']






code d'erreur 2eme type
----------------------------------
Une erreur est apparue lors de l'exécution du code python :

Traceback (most recent call last):
  File "C:/Users/jean-philippe.gallar/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 1442, in upload_qgis_layers
    SQL,params=self.saveLayer(layer, name, charset, srid, selected,False)
  File "C:/Users/jean-philippe.gallar/.qgis/python/plugins\QspatiaLite\qspatialite.py", line 156, in save_layer
    geometry=geom[vlayer.geometryType()]
IndexError: list index out of range

Version de Python :
2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)]


Version de QGIS :
1.7.0-Wroclaw Wroclaw, 63ecdd7

Chemin vers Python : 
['C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\GeoCoding', 
'C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\GeoCoding', 
'C:/PROGRA~1/QUANTU~1/apps/qgis/./python', 
'C:/Users/jean-philippe.gallar/.qgis/python', 
'C:/Users/jean-philippe.gallar/.qgis/python/plugins', 
'C:/PROGRA~1/QUANTU~1/apps/qgis/./python/plugins', 
'C:\\PROGRA~1\\QUANTU~1\\bin\\python25.zip', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\DLLs', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\plat-win', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\lib-tk', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\qgis\\bin', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\win32', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\win32\\lib', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\Pythonwin', 
'C:\\PROGRA~1\\QUANTU~1\\apps\\Python25\\lib\\site-packages\\wx-2.8-msw-unicode'
, 'C:\\Users\\jean-philippe.gallar\\.qgis\\python\\plugins\\fTools\\tools', 
'Z:/Am\xc3\xa9nagement urbain/0--Projets et \xc3\xa9tudes en cours--0/Plans 
pour le Service D.P/Signal\xc3\xa9tique verticale']

What steps will reproduce the problem?
join a attribute table to a spatial table
then load in qspatialite
no joined field is present

This forces the user to join data in SQLITE afterward, and break possible 
existing workflow.  Many user do not know SQL to join data in sqlite. 

When trying to install plugin I get 
"This plugin is broken
invalid literal for int() with base 10: '2-spatialite'"

When I first tried to install the plugin it failed complaining that it could 
not find pyspatialite.  I installed 

pip install pyspatialite==2.6.2-spatialite.2.4.0-4

after using brew to install headers of proj.


Oops -- I think I see part of what is going on -- the installer is expecting an 
integer subversion version for pyspatialite 

What steps will reproduce the problem?
1. create layer " test'layer "
2. upload via QSpatiaLite


I'm working on it,
try to avoid filenames with special characters.

--> What steps will reproduce the problem?

1. Load a shapefile on QGIS -> Select some features on that layer
2. QSpatiaLite -> Import QGIS Layer -> Import only selected values


--> What is the expected output? What do you see instead?

I get the following error: 

An error has occured while executing Python code:

Traceback (most recent call last):
  File "/home/pedro/.qgis//python/plugins/QspatiaLite/importQgis/importQgis.py", line 64, in run
    if not self.parent.db.uploadQgisVectorLayer(layer, tableName=self.tablenames[i], srid=self.srid, selected=self.selected):
  File "/home/pedro/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 140, in uploadQgisVectorLayer
    select_ids=vlayer.selectedFeaturesIds()
NameError: global name 'vlayer' is not defined

Python version:
2.7.3 (default, Aug  1 2012, 05:27:35) 
[GCC 4.6.3]

QGIS version:
1.9.0-Master Master, exported


--> What version of the product are you using? On what operating system?
QGIS version 1.9.0-Master
QSpatiaLite 6.0.4
Xubuntu 12.04

Geometry Type not recognized on linux

Qgis geotypes:
Polygon
Point
LineString
MultiPolygon
MultiPoint
MultiLineString

Hi,

After the API cleanup merged to Git by Alexander Bruy
https://github.com/qgis/Quantum-GIS/commit/5e45a22d061942f9e4cdaf09416dd5f3ee659
b13  

I get an AttributeError when doing 'Import QGIS Layers'.


--> What steps will reproduce the problem?

1. Load a shapefile on QGIS
2. QSpatiaLite -> Import QGIS Layer


--> What is the expected output? What do you see instead?

An error has occured while executing Python code:

Traceback (most recent call last):
  File "/home/pedro/.qgis//python/plugins/QspatiaLite/importQgis/importQgis.py", line 29, in browseSRID
    self.ui.SRID.setText(dialog.getProjection())
  File "/home/pedro/.qgis//python/plugins/QspatiaLite/Classes/dialogSRS.py", line 32, in getProjection
    if self.selector.selectedEpsg() != 0:
AttributeError: 'QgsProjectionSelector' object has no attribute 'selectedEpsg'

Python version:
2.7.3 (default, Aug  1 2012, 05:27:35) 
[GCC 4.6.3]

QGIS version:
1.9.0-Master Master, exported


--> What version of the product are you using? On what operating system?
QGIS version 1.9.0-Master
QSpatiaLite 6.0.5
Xubuntu 12.04


--> Please provide any additional information below.

More information about this API cleanup:
http://osgeo-org.1560.n6.nabble.com/API-cleanup-td5023896.html 
http://hub.qgis.org/wiki/quantum-gis/API_changes_for_version_20 

What steps will reproduce the problem?
1. load in qgis 'commune.shp' SRID IGNF:RGF93CC47 ID:10110
2. In Qspatialite new db : myDB.sqlite
3. uploag Tables : QGIS layer = commune.shp, New Table = commune, SRID = ... 
select SRID IGNF:RGF93CC47 ID:10110

What is the expected output? What do you see instead?
SRID must be INTEGER

4. or if SRID = 10110

What is the expected output? What do you see instead?
Invalid SRID

What version of the product are you using? On what operating system?
qspatialite 2.4 on ubuntu 11.04 AMD 64 with qgis 1.8 and gdal 1.9

Please provide any additional information below.
Perhaps Select Qgis ID instead of EPSG ID ?

This is not an issue, but an enhancement request.

Using "import QGIS/GDAL layer" from qspatialite you can't specify the ogr/gdal 
option of -gt which should improve performance.

The backend, ogr2ogr uses -gt 200 which is very low for importing data to 
spatialite. Increasing that value increases performance dramatically.

The only way to use that option is to put it into the "Data Source" creation 
options in the layer "Save As..." window. But this way you can only do one 
layer at a time, whereas in qspatialite I can do them in batch, but because I 
can't specify a custom -gt (like -gt 1024) it is slow to import shapefiles from 
qspatialite.

This is a much needed improvement to this utility.

What steps will reproduce the problem?
1. delete a database from outside of qgis
2. open qspatialite, you get the errors shown below and qspatialite does not 
load
3. workaround is to remove the database from qgis db manager

message box: 

Can't connect to DataBase: /backup/Etienne/tmp/myDB.sqlite
Error unable to open database file

python error:
An error has occured while executing Python code:

Traceback (most recent call last):
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/qspatialite.py", line 68, in run
    dlg = QspatiaLiteApp(self.iface)
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line 79, in __init__
    self.changeDb(max(0,self.connections['idx']))
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line 143, in changeDb
    self.drawTreeView()
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line 148, in drawTreeView
    model=self.db.createTreeModel()
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 100, in createTreeModel
    self.getTables()
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 73, in getTables
    header,data=self.executeQuery(query)
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 44, in executeQuery
    cursor=self.connectionObject.cursor()
AttributeError: Database instance has no attribute 'connectionObject'

Python version:
2.7.2+ (default, Oct  4 2011, 20:41:12) 
[GCC 4.6.1]

QGIS version:
1.8.0-Lisboa Lisboa, c64bb9d

What steps will reproduce the problem?
1. import two tables in QSpatilaite
2. create spatial indexes 
select createspatialindex(  'GeoSirene_2006_27561' ,'geometry' )
select createspatialindex( 'Communes_pm_recues','geometry' )
3. trying to use an RTree in an SQL query
select 
 s.'FID',
 c.'NOM_COMM' 
from  "GeoSirene_2006_27561" as s
join  "Communes_pm_recues" as c on (
st_intersects(s.geometry, c.geometry)
) and s.'PKUID'  in (
select  'pkid' 
from "idx_Communes_pm_recues_Geometry"
where  'pkid' match RTreeintersects (
        MbrMinX(s.geometry),
        MbrMinY(s.geometry),
        MbrMaxX(s.geometry),
        MbrMaxY(s.geometry)))

4. run SQL

What is the expected output? What do you see instead?
an error message 
The SQL query seems to be invalid.
no such function: RTreeintersects


What version of the product are you using? On what operating system?
QSpatialite V7
QGIS 2.6
Ubuntu 14.04

Please provide any additional information below.

What steps will reproduce the problem?
1.Load Qspatialite plugin
2.
3.

What is the expected output? What do you see instead?
"
Une erreur est apparue lors de l'exécution du code Python :

Traceback (most recent call last):
  File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/qspatialite.py", line 68, in run
    dlg = QspatiaLiteApp(self.iface)
  File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/QspatiaLiteApp.py", line 80, in __init__
    self.changeDb(max(0,self.connections['idx']))
  File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/QspatiaLiteApp.py", line 141, in changeDb
    self.db=Database(self.connections['path'][index])
  File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/Classes/Database.py", line 19, in __init__
    self.connection()
  File "/Users/my_account/.qgis2/python/plugins/QspatiaLite/Classes/Database.py", line 34, in connection
    self.connectionObject.enable_load_extension(True)
AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute 
'enable_load_extension'


Version de Python :
2.7.6 (default, Sep  9 2014, 15:04:36) 
[GCC 4.2.1 Compatible Apple LLVM 6.0 (clang-600.0.39)]


Version de QGIS :
2.6.1-Brighton Brighton, 

Chemin vers Python : ['/Users/my_account/.qgis2/python/plugins/processing', 
'/Applications/QGIS.app/Contents/MacOS/../Resources/python', 
u'/Users/my_account/.qgis2/python', u'/Users/my_account/.qgis2/python/plugins', 
'/Applications/QGIS.app/Contents/MacOS/../Resources/python/plugins', 
'/Library/Frameworks/SQLite3.framework/Versions/C/Python/2.7', 
'/Library/Frameworks/GEOS.framework/Versions/3/Python/2.7', 
'/Library/Python/2.7/site-packages/numpy-override', 
'/Library/Python/2.7/site-packages/matplotlib-override', 
'/Library/Frameworks/GDAL.framework/Versions/1.11/Python/2.7/site-packages', 
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python27.zip', 
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7', 
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-dar
win', 
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac
', 
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac
/lib-scriptpackages', 
'/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python', 
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-tk',

'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-old'
, 
'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynl
oad', 
'/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyOb
jC', '/Library/Python/2.7/site-packages', 
'/Users/my_account/.qgis2/python/plugins/MetaSearch/ext-libs', 
'/Users/my_account/.qgis2/python/plugins/mmqgis/forms', 
'/Users/my_account/.qgis2/python/plugins/QuickMultiAttributeEdit/forms', 
'/Applications/QGIS.app/Contents/Resources/python/plugins/fTools/tools']
"

What version of the product are you using? On what operating system?
7.0.3 on QGIS 2.6.1 Mac OS Yosomite

Please provide any additional information below.
Version 7.0 works.

What steps will reproduce the problem?
1. removed old sqlite file, just open before
2. try to open spatialite 
3. warning file doesn't exist, then crash

What is the expected output? What do you see instead?
Open with no error if removed file doesn't exist 

What version of the product are you using? On what operating system?
Ubuntu 4.04 64 bit 
Qgis 2.6.1-Brighton

qspatialite 7.0.4 (in /home/ubuntu/.qgis2/python/plugins/QspatiaLite)   


Please provide any additional information below.
workaround restore the old file, even with different content, into 
path/filename.sqlite showed by dialog...

--> What steps will reproduce the problem?

1. Create a Spatialite database on a folder with non ascii characters (accents, 
spaces, etc.) as name, or with that characters within the path to the folder, 
eg, /home/pedro/Área de Trabalho/dbtest.sqlite;
2. Create a SQL query;
3. Make 'Create Spatial Table & Load in QGIS'.

--> What is the expected output? What do you see instead?

I get the following error: 

An error has occured while executing Python code: 

Traceback (most recent call last): 
  File "/home/pedro/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line 221, in runQuery 
    table[0].loadToQgis() 
  File "/home/pedro/.qgis//python/plugins/QspatiaLite/Classes/Table.py", line 76, in loadToQgis 
    print uri.uri() 
UnicodeEncodeError: 'ascii' codec can't encode character u'\xc1' in position 
20: ordinal not in range(128) 

Python version: 
2.7.3 (default, Aug  1 2012, 05:27:35) 
[GCC 4.6.3] 

QGIS version: 
1.9.0-Master Master, exported 


--> What version of the product are you using? On what operating system?

QGIS version 1.9.0-Master
QSpatiaLite 6.0.4
Xubuntu 12.04

What steps will reproduce the problem?
1.When I try create a new DataBase, Spatialite plugin return the dialog error 
box:
The SQL query seems to be invalid. no suck table: views_goemetry_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) ?

3.When I click in the YES button, a new dialog error box open with the text:

Unable to convert Database to SpatiaLite

4.When I click in OK button, another dialog error box open with the text:

The SQL query seems to be invalid.


What is the expected output? What do you see instead?
I whant create a nem DB and import geometry layers. The DataBase was set up, 
but I cant import spatial layers.


What version of the product are you using? On what operating system?
I use Qgis 1.8.0 and QSpatialite 6.0.4. My OS is Windows 7, 64 bits, Running in 
network. 


Please provide any additional information below.

What about compatibility with QGIS 2.0.1


What version of the product are you using? On what operating system?
QSpatiallite 6.0.7
QGIS 2.0.1 64-bit
Windows 7

What steps will reproduce the problem?
1. Execute a query based on joined tables (geometry in one table with a common 
id field for the join)
2. Select option 'Load in QGIS as spatial layer' before executing query
3. In QGIS:
a) open the attribute table for the new layer, 
b) or select the 'identify features' function,
c) or select the 'select features by...' function

What is the expected output? What do you see instead?
The geometry is present and visible, the records exist in the attribute table 
but 
a) all fields are listed as 'error'.
b) The 'identify features' function does not - no data is found
c) only one feature is selected irrespective of how many are within the area 
selected (and within the attribute table the selected row is marked with 
'error' in each field)

What version of the product are you using? On what operating system?
QGIS 1.8.0 ; qspatialite 6.0.5 ; Windows XP SP3

Please provide any additional information below.
This issue did not occur with the previous version (prior to the interface 
being updated) on QGIS 1.7.x - I found it a really useful plugin and generated 
a project database specifically because I could manipulate the spatial data 
(which I'd never been able to do until I found qspatialite).

I can get around this if I execute the SQL statement with the option 'create 
spatial table and load in QGIS' but I think that this then breaks the link with 
the original dataset, which makes it more of a static snapshot than a dynamic 
database.
Thanks for your great work on this plugin.

What steps will reproduce the problem?
1. Going to the SQL free text entry tab
2. Writing any SQL code of length
3. Trying to observe the huge code font without scrolling around. 

What is the expected output? Output is normal.  The font is too large.


What version of the product are you using? Qspatialite 6.0.8 On what operating 
system? Windows XP with QGIS 1.8


Please provide any additional information below.
I appreciate large fonts, but this is even huge by my standard.

Hi Romain, 
a very convenient and small feature would be to allow executing SQL query only 
for selected text in SQL dialog. 
This is very usefull in PGadmin and DBMmanager. 
A bientôt
Régis

The plugin does not load in QGIS master due to lack of a metadata.txt file. 
Find attached a metadata.txt which works for me.

What steps will reproduce the problem?
1. Attempt to activate plugin from menu or shortcut
2.
3.

What is the expected output? What do you see instead?

AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute 
'enable_load_extension'

What version of the product are you using? On what operating system?


Please provide any additional information below.

Hi (bonjour Romain), 

In versions  7.0.2 et 7.0.1, on QGIS 2.2, we can't import correctly date 
fields. They are converted to  PyQt4.Core.Qdate text objects. 
See attached image. 
Quite a severe bug preventing us from using Qspatialite. 

Cheers 
Régis

I'm not sure what causes database to init itself so long. What I found out is 
that adding:

h,d=self.executeQuery("Select InitSpatialMetadata()",commit=True)
h,d=self.executeQuery("Select InitSpatialMetadata(1)",commit=True) to your 
Database class really helps. 

Thanks for great peace of code ! 

I just started using qspatialite today, and I really like ot. I came up with 
some simple UI improvements.

- add close button to the main window
- set the title for the main window (was Dialog)
- wait cursor when loading OGR file(s)
- use .shp by default instead of .dbf as this can be confusing

attaching a patch againt 6.0.1

With 4.08 it is again giving the message:

"Plugin has disappeared

The plugin seems to have been installed but I don't know where. Probably the 
plugin package contained a wrong named directory.
Please search the list of installed plugins. I'm nearly sure you'll find the 
plugin there, but I just can't determine which of them it is. It also means 
that I won't be able to determine if this plugin is installed and inform you 
about available updates. However the plugin may work. Please contact the plugin 
author and submit this issue."

What steps will reproduce the problem?
1. click on import ogr layer
2. select shapefile and add to list of files
3. click ok

What is the expected output? What do you see instead?

An error has occured while executing Python code:

Traceback (most recent call last):
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/importOgr/importOgr.py", line 147, in validate
    if not self.parent.db.importGisFile( item[0], item[1], int(item[2]),item[3]):
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 271, in importGisFile
    return self.uploadQgisVectorLayer(layer, srid, tableName=tableName)
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 161, in uploadQgisVectorLayer
    for id,name in provider.fields().iteritems():
AttributeError: 'QgsFields' object has no attribute 'iteritems'

Python version:
2.7.3 (default, Sep 26 2012, 21:53:55) 
[GCC 4.7.2]


QGIS version:
1.9.0-Master Master, db7b46a

Python path: ['/home/soft/share/qgis/python', '/home/tourigny/.qgis//python', 
'/home/tourigny/.qgis//python/plugins', '/home/soft/share/qgis/python/plugins', 
'/home/soft/lib/python2.7/site-packages', '/usr/lib/python2.7', 
'/usr/lib/python2.7/plat-linux2', '/usr/lib/python2.7/lib-tk', 
'/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload', 
'/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', 
'/usr/lib/python2.7/dist-packages/PIL', 
'/usr/lib/python2.7/dist-packages/gst-0.10', 
'/usr/lib/python2.7/dist-packages/gtk-2.0', '/usr/lib/pymodules/python2.7', 
'/usr/lib/python2.7/dist-packages/ubuntu-sso-client', 
'/home/soft/share/qgis/python/plugins/fTools/tools']


What version of the product are you using? On what operating system?


Please provide any additional information below.

An error has occured while executing Python code:

Traceback (most recent call last):
  File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialite.py", line 68, in run
    dlg = QspatiaLiteDialog(self.load_to_canvas,self.get_layer_names,self.save_layer,self.delete_tmpshp, self.import_gis_files, self.viewresult, self.export2ogr, self.iface.mainWindow())
  File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 103, in __init__
    if not self.connect_to_spatialite(): #get connectionSettings and connection to spatialite DB
  File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 1225, in connect_to_spatialite
    self.prepare_tree() # prepare tree for new DB
  File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 726, in prepare_tree
    columnsList = self.get_columns(record[0])
  File "C:/Users/Roman/.qgis/python/plugins\QspatiaLite\qspatialitedialog.py", line 1182, in get_columns
    rep=cursor.execute(query)
OperationalError: no such module: VirtualSpatialIndex

Python version:
2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)]


QGIS version:
1.7.0-Wroclaw Wroclaw, 63ecdd7

What steps will reproduce the problem?
1.click on import ogr layer
2.choose shapefile
3.click on SRID selector button

What is the expected output? What do you see instead?

An error has occured while executing Python code:

Traceback (most recent call last):
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/importOgr/importOgr.py", line 46, in browseSRID
    self.ui.SRID.setText(dialog.getProjection())
  File "/home/tourigny/.qgis//python/plugins/QspatiaLite/Classes/dialogSRS.py", line 32, in getProjection
    if self.selector.selectedEpsg() != 0:
AttributeError: 'QgsProjectionSelector' object has no attribute 'selectedEpsg'

Python version:
2.7.3 (default, Sep 26 2012, 21:53:55) 
[GCC 4.7.2]


QGIS version:
1.9.0-Master Master, db7b46a

Python path: ['/home/soft/share/qgis/python', '/home/tourigny/.qgis//python', 
'/home/tourigny/.qgis//python/plugins', '/home/soft/share/qgis/python/plugins', 
'/home/soft/lib/python2.7/site-packages', '/usr/lib/python2.7', 
'/usr/lib/python2.7/plat-linux2', '/usr/lib/python2.7/lib-tk', 
'/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload', 
'/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', 
'/usr/lib/python2.7/dist-packages/PIL', 
'/usr/lib/python2.7/dist-packages/gst-0.10', 
'/usr/lib/python2.7/dist-packages/gtk-2.0', '/usr/lib/pymodules/python2.7', 
'/usr/lib/python2.7/dist-packages/ubuntu-sso-client', 
'/home/soft/share/qgis/python/plugins/fTools/tools']


What version of the product are you using? On what operating system?


Please provide any additional information below.

this with latest plugin, using master (1.9)

I cannot run the plugin because of module missing.

I can't find that module in the OpenSuse repository, and python community 
repository. 

I'm using QGIS 2,0 and OpenSuse 13,1

Where can I find module pyspatialite with dependencies, because I've found that 
module at:
packages.altlinux.org/en/Sisyphus/srpms/python-module-pyspatialite/get

but if I try install it I get: 

nothing provides python-modules needed by 
python-module-pyspatialite-3.0.1-alt1.i586.

Thanks for answer, Tom