[Qgis-user] SQLite plugin

Thu Oct 25 07:26:31 PDT 2012

Looks like a different error now, and one that might really be related to something wrong with pyspatialite.

If you installed QGIS/GDAL a while ago, you should update.  I did have a problem in the SQLite framework at one point where it wouldn't load the spatialite stuff.  Fixed in the latest frameworks.

On Oct 25, 2012, at 9:09 AM, Frazier, Tyler James wrote:

> When I try to load QGIS layers to SQLite using the plugin I get the following error ... I assumed SQLite was installed as part of the GDAL bundle, but I did that some time ago.
> 
> An error has occured while executing Python code:
> 
> Traceback (most recent call last):
>   File "/Users/tyfrazier/.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 "/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 249, in uploadQgisVectorLayer
>     header,data=self.executeQuery("""INSERT INTO "%s" VALUES (%s,%s)"""%(tableName,','.join([unicode(value).encode('utf-8') for value in values_auto]),','.join('?'*len(values_perso))),tuple([unicode(value) for value in values_perso]),commit=True)
>   File "/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 45, in executeQuery
>     cursor.execute(query,params)
> IntegrityError: ea_r1.Geometry violates Geometry constraint [geom-type or SRID not allowed]
> 
> Python version:
> 2.7.1 (r271:86832, Jul 31 2011, 19:30:53) 
> [GCC 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00)]
> 
> 
> QGIS version:
> 1.8.0-Lisboa Lisboa, 
> 
> Python path: ['/Applications/QGIS.app/Contents/MacOS/../Resources/python', '/Users/tyfrazier/.qgis//python', '/Users/tyfrazier/.qgis//python/plugins', '/Applications/QGIS.app/Contents/MacOS/../Resources/python/plugins', '/Library/Frameworks/SQLite3.framework/Versions/3/Python/2.7', '/Library/Python/2.7/site-packages/numpy-override', '/Library/Frameworks/GDAL.framework/Versions/1.9/Python/2.7/site-packages', '/Library/Frameworks/cairo.framework/Versions/1/Python/2.7', '/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-darwin', '/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-dynload', '/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyObjC', '/Library/Python/2.7/site-packages', '/Library/Python/2.7/site-packages/PIL', '/Applications/QGIS.app/Contents/Resources/python/plugins/fTools/tools', '/Users/tyfrazier/Documents/workspace/frazier/simpop_accra/mapping/qgis_project']
> 
> 
> On Oct 25, 2012, at 3:31 PM, William Kyngesburye wrote:
> 
>> It looks like Tyler is on OS X.  My SQLite framework includes pyspatialite.  If it was missing, wouldn't there be an python import error instead?
>> 
>> On Oct 25, 2012, at 6:50 AM, Noli Sicad wrote:
>> 
>>> Hi Tyler,
>>> 
>>> You need to install pyspatialite.
>>> 
>>> Find out first the version of your spatialtite and follow the
>>> instruction on how to install pyspatilate here.
>>> 
>>> http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/python.html
>>> 
>>> Noli
>>> 
>>> On 10/25/12, Frazier, Tyler James <tyler.j.frazier at tu-berlin.de> wrote:
>>>> Hi, I was trying to load a QGIS layer into SQLite using the SQLite plugin
>>>> and get the following error -- not sure what to do?  Any suggestions?
>>>> thanks! Ty
>>>> 
>>>> An error has occured while executing Python code:
>>>> 
>>>> Traceback (most recent call last):
>>>> File
>>>> "/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line
>>>> 358, in importTxt
>>>>   self.app=ImportTxt(self)
>>>> File
>>>> "/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/importTxt/importTxt.py",
>>>> line 30, in __init__
>>>>   self.ui.charsetList_CSV.insertItems(0, self.charset)
>>>> TypeError: QComboBox.insertItems(int, QStringList): argument 2 has
>>>> unexpected type 'list'
>>>> 
>>>> Python version:
>>>> 2.7.1 (r271:86832, Jul 31 2011, 19:30:53)
>>>> [GCC 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00)]
>>>> 
>>>> 
>>>> QGIS version:
>>>> 1.8.0-Lisboa Lisboa,
>>>> 
>>>> Python path: ['/Applications/QGIS.app/Contents/MacOS/../Resources/python',
>>>> '/Users/tyfrazier/.qgis//python', '/Users/tyfrazier/.qgis//python/plugins',
>>>> '/Applications/QGIS.app/Contents/MacOS/../Resources/python/plugins',
>>>> '/Library/Frameworks/SQLite3.framework/Versions/3/Python/2.7',
>>>> '/Library/Python/2.7/site-packages/numpy-override',
>>>> '/Library/Frameworks/GDAL.framework/Versions/1.9/Python/2.7/site-packages',
>>>> '/Library/Frameworks/cairo.framework/Versions/1/Python/2.7',
>>>> '/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-darwin',
>>>> '/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-dynload',
>>>> '/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyObjC',
>>>> '/Library/Python/2.7/site-packages',
>>>> '/Library/Python/2.7/site-packages/PIL',
>>>> '/Applications/QGIS.app/Contents/Resources/python/plugins/fTools/tools',
>>>> '/Users/tyfrazier/Documents/workspace/frazier/simpop_accra/mapping/qgis_project']
>>>> -----
>>>> Tyler Frazier
>>>> Department of Transportation Planning and Telematics
>>>> Technical University Berlin
>>>> http://www.vsp.tu-berlin.de/
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>> 
>> -----
>> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
>> http://www.kyngchaos.com/
>> 
>> "Mon Dieu! but they are all alike.  Cheating, murdering, lying, fighting, and all for things that the beasts of the jungle would not deign to possess - money to purchase the effeminate pleasures of weaklings.  And yet withal bound down by silly customs that make them slaves to their unhappy lot while firm in the belief that they be the lords of creation enjoying the only real pleasures of existence....
>> 
>> - the wisdom of Tarzan
>> 
>> 
> 
> -----
> Tyler Frazier
> Department of Transportation Planning and Telematics
> Technical University Berlin
> http://www.vsp.tu-berlin.de/
> 
> 
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/

"This is a question about the past, is it? ... How can I tell that the past isn't a fiction designed to account for the discrepancy between my immediate physical sensations and my state of mind?"

- The Ruler of the Universe