https://issues.qgis.org/https://issues.qgis.org/favicon.ico2019-04-23T07:04:49ZQGIS Issue TrackingQGIS Application - Bug report #21899: Spatialite isn't working correctly on macOShttps://issues.qgis.org/issues/21899?journal_id=1041472019-04-23T07:04:49ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>isn't this a plugin problem?</p> QGIS Application - Bug report #21899: Spatialite isn't working correctly on macOShttps://issues.qgis.org/issues/21899?journal_id=1042362019-04-27T12:54:49ZMRick -
<ul></ul><p>Giovanni Manghi wrote:</p>
<blockquote>
<p>isn't this a plugin problem?</p>
</blockquote>
<p>No since as I explained, I got it working under 2.18 version by installing an older SQLite version.<br />Plus if I load manually a previously created database from the database manager, the plugin won't be able to load it as well.<br />When opening the framework content, you can see the Python part PySQLite of Spatialite are missing in version 3.6.<br />It was the same problem in SQLite framework builds released after the 3.8.7.-1 version I listed above.<br />Plugins which are based on this python extension aren't working at all under Mac OS X.<br />But since under Python 3, PySQLite isn't supported, the SQLite3 version under Mac OS is probably missing some components dedicated to the Python 3 SQLite module and Spatialite which replace PySQLite.</p>
<p>When I run this command in the Python console, I get an error.</p>
<blockquote>
<p>import sqlite3<br />with sqlite3.connect(":memory:") as conn:<br />conn.enable_load_extension(True)<br />conn.load_extension("mod_spatialite")</p>
</blockquote>
<blockquote>
<p>Traceback (most recent call last):<br />File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/code.py", line 91, in runcode<br />exec(code, self.locals)<br />File "<input>", line 3, in <module><br />pysqlite2.dbapi2.OperationalError: dlopen(mod_spatialite.dylib, 10): image not found</p>
</blockquote> QGIS Application - Bug report #21899: Spatialite isn't working correctly on macOShttps://issues.qgis.org/issues/21899?journal_id=1042372019-04-27T12:56:45ZMRick -
<ul><li><strong>File</strong> <a href="/attachments/download/14855/Capture%20d%E2%80%99%C3%A9cran%202019-04-27%20%C3%A0%2014.51.47.png">Capture d’écran 2019-04-27 à 14.51.47.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/14854/Capture%20d%E2%80%99%C3%A9cran%202019-04-27%20%C3%A0%2014.39.11.png">Capture d’écran 2019-04-27 à 14.39.11.png</a> added</li></ul> QGIS Application - Bug report #21899: Spatialite isn't working correctly on macOShttps://issues.qgis.org/issues/21899?journal_id=1042382019-04-27T13:31:55ZMRick -
<ul></ul><p>I made a test:<br />I trashed all my complete Python installation Framework folder.<br />I trashed my QGIS application.</p>
<p>I reinstalled Python 3 and QGIS 3.6.2.</p>
<p>I still got the same issue.</p> QGIS Application - Bug report #21899: Spatialite isn't working correctly on macOShttps://issues.qgis.org/issues/21899?journal_id=1043182019-05-01T16:10:55ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Subject</strong> changed from <i>Spatialite isn't working correctly</i> to <i>Spatialite isn't working correctly on macOS</i></li><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li><li><strong>Operating System</strong> changed from <i>MacOS</i> to <i>macOS</i></li></ul> QGIS Application - Bug report #21899: Spatialite isn't working correctly on macOShttps://issues.qgis.org/issues/21899?journal_id=1044392019-05-04T11:49:15ZMRick -
<ul><li><strong>File</strong> <a href="/attachments/download/14888/Capture%20d%E2%80%99%C3%A9cran%202019-05-04%20%C3%A0%2013.44.36.png">Capture d’écran 2019-05-04 à 13.44.36.png</a> added</li></ul><p>This plugin does work well using PostgreSQL.<br />If I use this QGIS version, it does work perfectly as well.<br /><a class="external" href="https://lutraconsulting.github.io/qgis-mac-packager/">https://lutraconsulting.github.io/qgis-mac-packager/</a></p>
<p>It is definitely validating a trouble with the built of SQLite.</p>