error "No such module: fts5"

[huyingjie]

Thank you for your development of the workflow.

I set api. I used the workflow to search for a term and then got error message: "No such module: fts5"

How to solve it?

[orf]

Hmm, can you run python --version for me? I'd also recommend running brew install sqlite and see if that fixes things.

[orf]

Can you also run:

python -c 'print __import__("sqlite3").version' and python -c 'print __import__("sqlite3").sqlite_version' and show me the output?

I get 2.6.0 and 3.19.3

[huyingjie]

• python --version

  Python 3.6.1 :: Anaconda 4.4.0 (x86_64)

• python -c 'print __import__("sqlite3").version

 File "<string>", line 1
    print __import__("sqlite3").version
                   ^
SyntaxError: invalid syntax

• python -c 'print __import__("sqlite3").sqlite_version'

  no output

[orf]

Oh, your default system python is python 3? That's strange for macos

Are you running in a virtualenv? Can you run those commands with /usr/bin/python instead of python? This is the version Alfred uses.

[huyingjie]

I am new to python.

Do you mean /usr/bin/python quip.py --setkey "{query}" and /usr/bin/python quip.py "{query}"

[orf]

Hey @huyingjie, not quite. Try running:

/usr/bin/python --version

/usr/bin/python -c 'print __import__("sqlite3").version

/usr/bin/python -c 'print __import__("sqlite3").sqlite_version'

Just out of interest, you have installed the Alfred workflow and are running it through that, right?

[huyingjie]

• /usr/bin/python --version Python 2.7.10
• /usr/bin/python -c 'print __import__("sqlite3").version' 2.6.0
• /usr/bin/python -c 'print __import__("sqlite3").sqlite_version' 3.16.0

[orf]

Ahh, that's the difference. My sqlite_version is 3.21.0.

Can you run brew upgrade sqlite? That will fix the issue you are experiencing. If you're not using Homebrew right now you can get it here: https://brew.sh/

If you can do this and confirm it works I will add something into the readme. Sorry about this!

[huyingjie]

I run brew upgrade sqlite. The error still exists.

[orf]

Can you run brew link sqlite as well?

[orf]

Sorry, brew link sqlite --force

[huyingjie]

Linking /usr/local/Cellar/sqlite/3.21.0... 
Error: Could not symlink lib/pkgconfig/sqlite3.pc
/usr/local/lib/pkgconfig is not writable.

[orf]

Ok, last question: Are you on the latest MacOS release? Click About This Mac and tell me what version? According [to this page](https://github.com/yapstudios/YapDatabase/wiki/SQLite-version-(bundled-with-OS) you might be on 10.12

[huyingjie]

v 10.12.6

[orf]

Ahh, thank you. Ok, so this module uses a feature of Sqlite that requires MacOS 10.13. I can try and add some limited support for 10.12 soon :)

Thank you for your diagnostics!

[huyingjie]

Thank you.