<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div>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.</div>
<div><br>
</div>
<div>
<div style="margin-top: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; text-indent: 0px; ">
<!--StartFragment--><span style=" color:#ff0000;">An error has occured while executing Python code:</span><br>
<br>
Traceback (most recent call last):<br>
File "/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/importQgis/importQgis.py", line 64, in run<br>
if not self.parent.db.uploadQgisVectorLayer(layer, tableName=self.tablenames[i], srid=self.srid, selected=self.selected):<br>
File "/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 249, in uploadQgisVectorLayer<br>
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)<br>
File "/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/Classes/Database.py", line 45, in executeQuery<br>
cursor.execute(query,params)<br>
IntegrityError: ea_r1.Geometry violates Geometry constraint [geom-type or SRID not allowed]<br>
<br>
Python version:<br>
2.7.1 (r271:86832, Jul 31 2011, 19:30:53) <br>
[GCC 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00)]<br>
<br>
<br>
QGIS version:<br>
1.8.0-Lisboa Lisboa, <br>
<br>
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']<!--EndFragment--></div>
</div>
<div><br>
</div>
<br>
<div>
<div>On Oct 25, 2012, at 3:31 PM, William Kyngesburye wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div>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?<br>
<br>
On Oct 25, 2012, at 6:50 AM, Noli Sicad wrote:<br>
<br>
<blockquote type="cite">Hi Tyler,<br>
</blockquote>
<blockquote type="cite"><br>
</blockquote>
<blockquote type="cite">You need to install pyspatialite.<br>
</blockquote>
<blockquote type="cite"><br>
</blockquote>
<blockquote type="cite">Find out first the version of your spatialtite and follow the<br>
</blockquote>
<blockquote type="cite">instruction on how to install pyspatilate here.<br>
</blockquote>
<blockquote type="cite"><br>
</blockquote>
<blockquote type="cite"><a href="http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/python.html">http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/python.html</a><br>
</blockquote>
<blockquote type="cite"><br>
</blockquote>
<blockquote type="cite">Noli<br>
</blockquote>
<blockquote type="cite"><br>
</blockquote>
<blockquote type="cite">On 10/25/12, Frazier, Tyler James <<a href="mailto:tyler.j.frazier@tu-berlin.de">tyler.j.frazier@tu-berlin.de</a>> wrote:<br>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">Hi, I was trying to load a QGIS layer into SQLite using the SQLite plugin<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">and get the following error -- not sure what to do? Any suggestions?<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">thanks! Ty<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">An error has occured while executing Python code:<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">Traceback (most recent call last):<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">File<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">"/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/QspatiaLiteApp.py", line<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">358, in importTxt<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"> self.app=ImportTxt(self)<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">File<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">"/Users/tyfrazier/.qgis//python/plugins/QspatiaLite/importTxt/importTxt.py",<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">line 30, in __init__<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"> self.ui.charsetList_CSV.insertItems(0, self.charset)<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">TypeError: QComboBox.insertItems(int, QStringList): argument 2 has<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">unexpected type 'list'<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">Python version:<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">2.7.1 (r271:86832, Jul 31 2011, 19:30:53)<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">[GCC 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00)]<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">QGIS version:<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">1.8.0-Lisboa Lisboa,<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">Python path: ['/Applications/QGIS.app/Contents/MacOS/../Resources/python',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Users/tyfrazier/.qgis//python', '/Users/tyfrazier/.qgis//python/plugins',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Applications/QGIS.app/Contents/MacOS/../Resources/python/plugins',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Library/Frameworks/SQLite3.framework/Versions/3/Python/2.7',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Library/Python/2.7/site-packages/numpy-override',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Library/Frameworks/GDAL.framework/Versions/1.9/Python/2.7/site-packages',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Library/Frameworks/cairo.framework/Versions/1/Python/2.7',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python27.zip',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-darwin',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac/lib-scriptpackages',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-tk',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-old',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyObjC',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Library/Python/2.7/site-packages',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Library/Python/2.7/site-packages/PIL',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Applications/QGIS.app/Contents/Resources/python/plugins/fTools/tools',<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">'/Users/tyfrazier/Documents/workspace/frazier/simpop_accra/mapping/qgis_project']<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">-----<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">Tyler Frazier<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">Department of Transportation Planning and Telematics<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">Technical University Berlin<br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><a href="http://www.vsp.tu-berlin.de/">http://www.vsp.tu-berlin.de/</a><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">
<blockquote type="cite"><br>
</blockquote>
</blockquote>
<blockquote type="cite">_______________________________________________<br>
</blockquote>
<blockquote type="cite">Qgis-user mailing list<br>
</blockquote>
<blockquote type="cite"><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
</blockquote>
<blockquote type="cite"><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
<br>
-----<br>
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com><br>
<a href="http://www.kyngchaos.com/">http://www.kyngchaos.com/</a><br>
<br>
"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....<br>
<br>
- the wisdom of Tarzan<br>
<br>
<br>
</div>
</blockquote>
</div>
<br>
<div apple-content-edited="true">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div>-----</div>
<div>Tyler Frazier</div>
<div>Department of Transportation Planning and Telematics</div>
<div>Technical University Berlin</div>
<div><a href="http://www.vsp.tu-berlin.de/">http://www.vsp.tu-berlin.de/</a></div>
<div><br>
</div>
</div>
<br class="Apple-interchange-newline">
<br class="Apple-interchange-newline">
</div>
<br>
</body>
</html>