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!
YOS,
Kuzorra