SQLite Forum

Error: near line 1: no such module: fts5

Error: near line 1: no such module: fts5

(1) By Kuzorra on 2020-10-12 10:18:00 [source]

Hello All !

I am running the following query againt a Calibre database:

delete from books where id not in 
(select distinct book from books_custom_column_1_link 
left join custom_column_1 on custom_column_1.id = books_custom_column_1_link.value 
where custom_column_1.value like 'BAHN');

And just recently this gives me the following error :

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.

How can I check if sqlite3 (on a Synology NAS) is using FTS5 (and fix the obviously missing lib). And why is this command using FTS5 at all ? It looks to me like plain sql.

Thanks for any advice on this matter in advance!

YOS, Kuzorra

(2) By Matt (mattkuine) on 2020-10-14 12:43:40 in reply to 1 [link] [source]

FTS5 is a core SQLite module which is always included in the source code. You can download Fossil and run the command fossil clone https://www.sqlite.org/cgi/src to download the module.