Skip to content
This repository has been archived by the owner on Dec 1, 2020. It is now read-only.

"table quickfinder_info already exists" when creating QuickFinder file #50

Open
adamczi opened this issue Aug 24, 2016 · 2 comments
Open

Comments

@adamczi
Copy link

adamczi commented Aug 24, 2016

This is the error I get when I create a new QuickFinder file. The file is being created despite it.

Traceback (most recent call last): File "/home/user/.qgis2/python/plugins/quickfinder/gui/configuration_dialog.py", line 120, in create_QFTS_file create_FTS_file(filepath) File "/home/user/.qgis2/python/plugins/quickfinder/core/project_finder.py", line 56, in create_FTS_file cur.executescript(sql) OperationalError: table quickfinder_info already exists

Then when I load this file and perform a project search I get:

Traceback (most recent call last): File "/home/user/.qgis2/python/plugins/quickfinder/gui/project_search_dialog.py", line 76, in process ok, message = self.project_finder.recordSearch(self.projectSearch) File "/home/user/.qgis2/python/plugins/quickfinder/core/project_finder.py", line 219, in recordSearch self.deleteSearch(searchId, False) File "/home/user/.qgis2/python/plugins/quickfinder/core/project_finder.py", line 192, in deleteSearch cur.execute("DELETE FROM quickfinder_data WHERE search_id = '{0}';".format(searchId)) OperationalError: no such table: quickfinder_data

The result of search appears in the table though.

I haven't tested other functionalities.

@Bukmop89
Copy link

I've got the same problem by using sqlite database. With PostGis it work's well

@marcobra
Copy link

marcobra commented Dec 20, 2016

Can't use this plugin on Ubuntu, error executing Python code:
something wrong on creating new filesearch

OperationalError: table quickfinder_info already exists
Traceback (most recent call last):
File "/home/ubuntu/.qgis2/python/plugins/quickfinder/gui/configuration_dialog.py", line 120, in create_QFTS_file
create_FTS_file(filepath)
File "/home/ubuntu/.qgis2/python/plugins/quickfinder/core/project_finder.py", line 56, in create_FTS_file
cur.executescript(sql)
OperationalError: table quickfinder_info already exists

Python version: 2.7.6 (default, Oct 26 2016, 20:33:43) [GCC 4.8.4]
QGIS version: 2.18.2 Las Palmas, 102ee87

Installed version: 3.3.0 (in /home/ubuntu/.qgis2/python/plugins/quickfinder)
Available version: 3.3.0 (in QGIS Official Plugin Repository)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants