QSpatialite broken after update to QGIS 2.18

Question

Lately I updated from QGIS 2.14 (LTS) to 2.18 on Mac OS X. Since then, the QSpatiaLite plugin has ceased to work, yielding following error message:

I have tried the following to repair the problem, without success:

1. Removing the SpatiaLite DB from the DB Manager Plugin and re-adding it. I am then normally prompted by SpatiaLite to create a new DB, however SpatiaLite can't connect to it, I get the following two errors:

1. Reinstalling QGIS 2.14 with all package dependencies from http://www.kyngchaos.com/software/qgis

2. Installing QGIS from brew as

   brew install osgeo/osgeo4mac/qgis-lts

3. Removing all QGIS files with terminal, like:

   sudo rm -R /Library/Frameworks/SQLite3.framework/ sudo rm -R /Library/Frameworks/GEOS.framework/ sudo rm -R /Library/Frameworks/GDAL.framework/ sudo rm -R /Users/[myusername]/.qgis2 sudo rm -R /Applications/QGIS.app/

Answer 1

QSpatialite uses Pyspatialite and there is a path problem in the Kyng Chaos SQLite installer, look at Mac QGIS 2.14: error loading module “processing”. No module named pyspatialite [duplicate] and Pyspatialite installation error on MacOSX (QGIS plugin)