search

3nids / quickfinder

Quick Finder is a QGIS 2.x plugin offering a single place to perform searches on project layers and online remote services
http://3nids.github.io/quickfinder/
Other
8 stars 14 forks source link

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

Open adamczi opened 7 years ago

adamczi commented 7 years ago

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 commented 7 years ago

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

marcobra commented 7 years ago

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)