More

How to fix Quickfinder OperationalError: table quickfinder_info already exists?

How to fix Quickfinder OperationalError: table quickfinder_info already exists?


This is what I am getting when I try to search in project layers and create a .qfts file to use quickfinder on a local shapefile.

An error has occured while executing Python code:

Traceback (most recent call last): File "C:/Users/xxxxxx/.qgis2/python/pluginsquickfinderguiconfigurationdialog.py", line 120, in createQFTSfile createFTSfile(filepath) File "C:/Users/xxxxxxxx/.qgis2/python/pluginsquickfindercoreprojectfinder.py", line 55, in createFTSfile cur.executescript(sql) OperationalError: table quickfinder_info already exists

Python version: 2.7.5 (default, May 15 2013, 22:44:16) [MSC v.1500 64 bit (AMD64)]

QGIS version: 2.8.2-Wien Wien, 1b929ef

Python path: ['C:/Users/xxxxxxx/.qgis2/python/pluginsprocessing', 'C:/PROGRA~1/QGISWI~1/apps/qgis/./python', u'C:/Users/xxxxxxx/.qgis2/python', u'C:/Users/xxxxxxxx/.qgis2/python/plugins', 'C:/PROGRA~1/QGISWI~1/apps/qgis/./python/plugins', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesmatplotlib-1.3.1-py2.7-win-amd64.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packages ose-1.3.3-py2.7.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packages ornado-4.0.1-py2.7-win-amd64.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesackports.ssl_match_hostname-3.4.0.2-py2.7.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagescertifi-14.05.14-py2.7.egg', 'C:PROGRA~1QGISWI~1inpython27.zip', 'C:PROGRA~1QGISWI~1appsPython27DLLs', 'C:PROGRA~1QGISWI~1appsPython27lib', 'C:PROGRA~1QGISWI~1appsPython27libplat-win', 'C:PROGRA~1QGISWI~1appsPython27liblib-tk', 'C:PROGRA~1QGISWI~1in', 'C:PROGRA~1QGISWI~1appsPython27', 'C:PROGRA~1QGISWI~1appsPython27libsite-packages', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesPIL', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesjinja2-2.7.2-py2.7.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesmarkupsafe-0.23-py2.7-win-amd64.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagespytz-2012j-py2.7.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packageswin32', 'C:PROGRA~1QGISWI~1appsPython27libsite-packageswin32lib', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesPythonwin', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesShapely-1.2.18-py2.7-win-amd64.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagessix-1.3.0-py2.7.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packageswx-2.8-msw-unicode', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesxlrd-0.9.2-py2.7.egg', 'C:PROGRA~1QGISWI~1appsPython27libsite-packagesxlwt-0.7.5-py2.7.egg', u'C:/Users/xxxxxxxxx/.qgis2//python', 'C:PROGRA~1QGISWI~1appsqgispythonpluginsfTools ools']


I figured it out this morning, the version that QGIS downloads from the "manage and install plugins… " dropdown is not the 2.8.2 verison, it was the 2.7.5 version. So to fix the issue, you must go and download from the plugin creators site, the correct version of QGIS you are running, then put that into the same spot where the wrong version was placed. I had to install the plugin with the old version, and then replaced that with the new(correct version) folder "quickfinder". Then toggle the quickfinder off and back on in the "manage and install plugins… " dropbox. I was then able to save my .qfts file and go through the rest of the steps to make quickfinder work.