https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-03-13T11:14:13ZQGIS Issue TrackingQGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=887112018-03-13T11:14:13ZJürgen Fischerjef@norbit.de
<ul><li><strong>Category</strong> changed from <i>Python plugins</i> to <i>Build/Install</i></li></ul> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=887122018-03-13T11:14:45ZJürgen Fischerjef@norbit.de
<ul><li><strong>Description</strong> updated (<a href="/journals/diff/88712?detail_id=77628" title="View differences">diff</a>)</li></ul> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=889992018-03-28T09:35:03ZSteven Kaystevendkay@gmail.com
<ul></ul><p>Arthur Vignacq wrote:</p>
<blockquote>
Hi, <br />I've installed QGIS3 from King Chaos today and found 5 different bug with:
<ul>
<li>Mask extension</li>
<li>nominatim extension</li>
<li>QBano extension</li>
<li>cartogram3 extension</li>
<li>db_manager</li>
</ul>
<p>The one most annoying is db_manager as I can't use spatialite with this error.</p>
<p>[...]</p>
</blockquote>
<p>I had a look into the SQLite support issue - this affects the KyngChaos build as of 3.0.0-3 (I've not tried this using brew). See <a class="external" href="https://gis.stackexchange.com/a/277071/55203">https://gis.stackexchange.com/a/277071/55203</a> .</p>
<p>The browser panel can still be used to add Spatialite/SQLite/GPKG, perhaps as this is using C++/GDAL rather than Python?</p>
<p>It seems that on the Mac, the standard python spatialite3 build is not compiled with loadable extension support as standard. See <a class="external" href="https://riccardo.forina.me/spatialite-for-python-does-not-work-on-osx/">https://riccardo.forina.me/spatialite-for-python-does-not-work-on-osx/</a></p>
<p>I could reproduce this outside of QGIS in standalone python using the standard Mac python 3.6, but the equivalent Brew-installed version works fine.</p> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=898032018-05-21T14:48:59ZRonan Lronanl@sctg.eu.org
<ul></ul><p>3.0.2 version from qgis.org has the same behaviour.<br />the problem comes with python 3 from python.org , enable_load_extensions is not compiled in . And because QGIS IS linked to this there is no way to use spatialite with python.</p>
<p>Also there is no way to user brewed python3 with QGIS 3</p> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=903502018-06-14T07:42:35ZArthur Vignacq
<ul></ul><p>Tested again with version 3.0.3 same problem.</p>
<p>Does anyone hava a solution to enable load extesion within pythn 3.6 and get rid of this.</p>
<p>I don't know how many people can't use database function because of this.</p> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=905112018-06-25T13:56:23ZHarrissou Santanna
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Would this workaround help: <a class="external" href="https://www.kyngchaos.com/blog/2018/20180406_qgis_tools_processing_workaround">https://www.kyngchaos.com/blog/2018/20180406_qgis_tools_processing_workaround</a>?</p> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=905542018-06-27T14:00:31ZArthur Vignacq
<ul></ul><p>Thank you, I already tried it, but nothing new with this :</p>
<pre>
AttributeError: 'sqlite3.Connection' object has no attribute 'enable_load_extension'
Traceback (most recent call last):
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_model.py", line 441, in rowCount
self._refreshIndex(parent, True)
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_model.py", line 490, in _refreshIndex
if item.populate():
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_model.py", line 167, in populate
if not connection.connect():
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/plugin.py", line 80, in connect
return self.connectToUri(uri)
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/plugin.py", line 109, in connectToUri
self.db = self.databasesFactory(self, uri)
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/plugin.py", line 66, in databasesFactory
return SLDatabase(connection, uri)
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/plugin.py", line 109, in __init__
Database.__init__(self, connection, uri)
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/plugin.py", line 218, in __init__
self.connector = self.connectorsFactory(uri)
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/plugin.py", line 112, in connectorsFactory
return SpatiaLiteDBConnector(uri)
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/connector.py", line 51, in __init__
self.connection = spatialite_connect(self._connectionInfo())
File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 596, in spatialite_connect
con.enable_load_extension(True)
AttributeError: 'sqlite3.Connection' object has no attribute 'enable_load_extension'
Python version: 3.6.5 (v3.6.5:f59c0932b4, Mar 28 2018, 03:03:55) [GCC 4.2.1 (Apple Inc. build 5666) (dot 3)]
QGIS version: 3.0.3-Girona Girona, exported
Python Path:
/Applications/QGIS3.app/Contents/MacOS/../Resources/python
/Users/arthur/Library/Application Support/QGIS/QGIS3/profiles/default/python
/Users/arthur/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins
/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins
/Library/Frameworks/Python.framework/Versions/3.6/lib/python36.zip
/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6
/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/lib-dynload
/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages
/Users/arthur/Library/Application Support/QGIS/QGIS3/profiles/default/python
/Users/arthur/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/DigitizingTools/tools
/Users/arthur/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/mmqgis/forms
/Users/arthur/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/NNJoin
</pre> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=921522018-08-25T15:30:55ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Any difference with 3.2/master?</p> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=974142018-12-23T07:24:47ZLinwood Creekmorevalinvescap@gmail.com
<ul></ul><p>I can confirm that the latest QGIS on Mac as of 22 December still has the DB Manager problem with Spatialite. I can't open or filter any spatialite files in QGIS and get the "extension" error referenced above. line 595 in the utils.py code.</p>
<p>I can't get Python to build on my Mac OS (running Sierra) so this seems like a lingering issue for lots of folks.</p> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=975012018-12-27T12:19:32ZLinwood Creekmorevalinvescap@gmail.com
<ul><li><strong>File</strong> <a href="/attachments/download/14027/extensionLineMac.png">extensionLineMac.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/14028/pythonSoftwareSqlite.png">pythonSoftwareSqlite.png</a> added</li></ul><p>Linwood Creekmore wrote:</p>
<blockquote>
<p>I can confirm that the latest QGIS on Mac as of 22 December still has the DB Manager problem with Spatialite. I can't open or filter any spatialite files in QGIS and get the "extension" error referenced above. line 595 in the utils.py code.</p>
<p>I can't get Python to build on my Mac OS (running Sierra) so this seems like a lingering issue for lots of folks.</p>
</blockquote>
<p>I searched around and found the exact line in the Python Source distribution that causes the problem. According to the python.org page on sqlite3 (<a class="external" href="https://docs.python.org/2/library/sqlite3.html#multithreading">https://docs.python.org/2/library/sqlite3.html#multithreading</a>), you need to delete a line from the setup.py file for your Python distribution. We need to delete line 1244 and rebuild python I assume. Others can try as well and report back. If I'm successful, will let you know.</p>
<p>I added to pictures to show the line and the instructions from python.org.</p> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=999652019-02-12T08:29:27Zbradypus -
<ul></ul><p>Hello,<br />it is still <strong>not</strong> working on: 3.4.4-Madeira<br />Some more info: <br /><pre>
QGIS code branch: Release 3.4
Compiled against Qt: 5.11.2
Running against Qt: 5.11.2
Compiled against GDAL/OGR:2.3.3
Running against GDAL/OGR: 2.3.3
Compiled against GEOS: 3.7.1-CAPI-1.11.0
Running against GEOS: 3.7.1-CAPI-1.11.1 27a5e771
PostgreSQL Client Version: 9.6.10
SpatiaLite Version: 4.4.0-RC1
QWT Version: 6.1.3
QScintilla2 Version: 2.10.8
PROJ.4 Version: 493
</pre></p> QGIS Application - Bug report #18430: Multiple extension and plugin bug QGIS3 osxhttps://issues.qgis.org/issues/18430?journal_id=1027832019-03-09T15:55:00ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Operating System</strong> changed from <i>Osx </i> to <i>macOS</i></li><li><strong>Category</strong> changed from <i>Build/Install</i> to <i>mac_os_specific</i></li><li><strong>Affected QGIS version</strong> changed from <i>3.0.0</i> to <i>3.4.4</i></li></ul><p>Please try with a new/clean profile.</p>