SQLite Forum

Error: near line 1: no such module: fts5
Hello All !

I am running the following query againt a Calibre database:

<pre>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');</pre>

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!