Skip to content

Troubleshooting

instance.id edited this page Mar 23, 2024 · 1 revision
Issue Cause Resolution

Windows: sqlite3.OperationalError: no such table: settings

Traceback (most recent call last):
  File "C:\PROGRA~1/SIDEEF~1/HOUDIN~1.653/houdini/python3.10libs\hdefereval.py", line 155, in _processDeferred
    result = code(*args, **kwargs)
  File "C:\Users/<your_user>/software/Searcher_0.1.4/Searcher/python3.10libs\searcher\searchersetup.py", line 285, in dbupdate
    chindex = getchangeindex(cur)
  File "C:\Users/<your_user>/software/Searcher_0.1.4/Searcher/python3.10libs\searcher\searchersetup.py", line 212, in getchangeindex
    cur.execute("SELECT indexvalue FROM settings")
sqlite3.OperationalError: no such table: settings
If you open Houdini but don't yet have the correct sqlite.dll in place (with FTS - Full-Text Search enabled) the database that searcher attempts to create is not correct due to Houdini having errored out early on in the setup process.

Ensure you have the correct sqlite.dll installed in
C:\Program Files\Side Effects Software\Houdini xx.x.xxx\bin (see README.md)

Navigate to the following location and locate the file searcher.db and delete it:

C:\\Users\\<your_user>\\Documents\\houdini20.0\\Searcher

Once you have the correct sqlite.dll in place, reopen Houdini. It will recreate searchers internal database, and you should be good to go.

Clone this wiki locally