no such module: fts5

See original GitHub issue

Issue Summary

site-packages\django\db\backends\sqlite3\base.py", line 421, in execute return Database.Cursor.execute(self, query) django.db.utils.OperationalError: no such module: fts5

Steps to Reproduce

  1. Start a new project with wagtail start myproject
  2. manage.py migrate

Technical details

Python 3.7.6 Django 3.2.10 wagtail 2.15.1

Issue Analytics

  • State:closed
  • Created 2 years ago
  • Comments:24 (1 by maintainers)

github_iconTop GitHub Comments

1reaction
gasmancommented, Jan 25, 2022

At this point this is extremely difficult to replicate, since you need an environment that’s old enough to not have sqlite-with-fts5 baked in, but new enough to evade the >3.19 version check, and new enough to let you install Python>=3.6 at all. The best I could do was to spin up an Ubuntu 16.04 instance in Vagrant and fake the sqlite version…

vagrant init ubuntu/xenial64
vagrant up
vagrant ssh
sudo apt update
sudo apt install -y python3 git curl build-essential libbz2-dev libssl-dev libreadline-dev libffi-dev libsqlite3-dev tk-dev
curl https://pyenv.run | bash
echo 'export PATH="$HOME/.pyenv/bin:$PATH"' >> ~/.bashrc
echo 'eval "$(pyenv init -)"' >> ~/.bashrc
echo 'eval "$(pyenv virtualenv-init -)"' >> ~/.bashrc
exec $SHELL
pyenv install 3.7.12
~/.pyenv/versions/3.7.12/bin/python -m venv ~/.venv/wagtail
source ~/.venv/wagtail/bin/activate
git clone https://github.com/wagtail/wagtail.git
cd wagtail
pip install -e .

# edit wagtail/search/backends/database/sqlite/utils.py and change (3, 19, 0) to (3, 1, 0)

cd ..
wagtail start myapp
cd myapp
./manage.py migrate

This does indeed fail with sqlite3.OperationalError: no such module: fts5, and updating the fts5_available function to catch sqlite3.OperationalError instead of django.db.OperationalError fixes it. PR incoming…

0reactions
gasmancommented, Jan 26, 2022

Fixed in #7893

Read more comments on GitHub >

github_iconTop Results From Across the Web

Error: near line 1: no such module: fts5 - SQLite Forum
Error: near line 1: no such module: fts5. I am using sqlite3 version 3.10.2. Strangly this behaviour started a couple of days ago....
Read more >
no such module: fts5 error with System.Data.SQLite.dll 1.0.101.0
101.0 and I get this error when execute the command "CREATE VIRTUAL TABLE tbl_fts USING fts5 (fld1, fld2)". error: no such module: fts5....
Read more >
unable to delete book in calibre 3 (after managing in calibre 5)
hello forum! at the moment i cannot delete books in calibre 3. SQLError: SQLError: no such module: fts5
Read more >
SQLError: no such module: fts5 - calibre - Launchpad Bugs
Hello, How can I resolve this, please ? calibre, version 2.68.0. ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such module: fts5.
Read more >
"no such module: FTS5" on UPDATE/DELETE - Emby
Greetings!I have been living with a "ghost" playlist issue for some time now (placed a m3u file in a lib folder, then deleted...
Read more >

github_iconTop Related Medium Post

No results found

github_iconTop Related StackOverflow Question

No results found

github_iconTroubleshoot Live Code

Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free

github_iconTop Related Reddit Thread

No results found

github_iconTop Related Hackernoon Post

No results found

github_iconTop Related Tweet

No results found

github_iconTop Related Dev.to Post

No results found

github_iconTop Related Hashnode Post

No results found