OperationalError: No Such Module:fts4

[ReddyKatta89]

Hello, I have tried this with Anaconda 32 Bit version. This worked perfectly. But due to performance issues, I uninstalled 32 Bit and Installed 64 Bit Version. When I try to execute my code, I get this error. Please assist me on this.

• 1. Will this only work with 32 Bit version Anaconda?
• 2. When I tried to install "FuzzyMatcher" for the 64 bit, it says version issue and cannot be installed. So I tried to manually keep the fuzzymatcher 32 bit installed files in the 64 bit site-libraries. The the above error occurs.

Please help me with this. any thanks in advance

[soliverc]

I had the same issue. I followed what somebody said on stack overflow and downloaded sqlite3 from here: https://www.sqlite.org/download.html

And then manually pasted into my python \bin folder, renaming the old version as sqlite3old. Seems to be working.

[ShahidaPervin]

I pasted the folder C:\Users\anaconda3\bin\sqlite-dll-win64-x64-3350500 But it does not solve my problem. I am still have the same problem OperationalError: no such module: fts4 Any further advice please? Thank you.

[anandpuravangara]

I had the same issue and there was not much real straight forward help available anywhere. My issue got resolved by copying sqlite3.exe and sqlite3.dll from the base conda environment into this environment. That is, from C:\Users\anand.puravangara\Anaconda3\Library\bin to C:\Users\anand.puravangara\Anaconda3\envs\Python39\Library\bin

The reason for the shortcut of copying the files was after figuring out the required options such as ENABLE_FTS3, ENABLE_FTS3_TOKENIZER,DSQLITE_ENABLE_FTS3,DSQLITE_ENABLE_FTS3_PARENTHESIS were enable in the former environment and I an not a C language expert to recompile sqllite3 in the new environment.

Below is the latest output of "pragma compile_options;" command in this environment

(base) C:\Users\anand.puravangara\Anaconda3\Library\bin>activate Python39

(Python39) C:\Users\anand.puravangara\Anaconda3\Library\bin>sqlite3 SQLite version 3.32.3 2020-06-18 14:00:33 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite>

(Python39) C:\Users\anand.puravangara\Anaconda3\Library\bin>sqlite3 ext4 SQLite version 3.32.3 2020-06-18 14:00:33 Enter ".help" for usage hints. sqlite> pragma compile_options; COMPILER=msvc-1916 ENABLE_COLUMN_METADATA ENABLE_DBSTAT_VTAB ENABLE_FTS3 ENABLE_FTS3_TOKENIZER ENABLE_FTS4 ENABLE_FTS5 ENABLE_GEOPOLY ENABLE_JSON1 ENABLE_RTREE ENABLE_UNLOCK_NOTIFY MAX_DEFAULT_PAGE_SIZE=32768 MAX_VARIABLE_NUMBER=250000 SECURE_DELETE THREADSAFE=1 sqlite>