search

uwdata / termite-data-server

Data Server for Topic Models
BSD 3-Clause "New" or "Revised" License
121 stars 46 forks source link

SQLite fulltext search index issues reported by Leo Claudino #18

Closed jcchuang closed 10 years ago

jcchuang commented 10 years ago

Eventual need to enable an extension to pysqlite2:

My version of the pysqlite2 did not have the fts extension enable when compiled and installed, so I was having problems with the database part of termite. This post explains the issue and gives instructions on how to solve the problem:

http://stackoverflow.com/questions/1545479/force-python-to-forego-native-sqlite3-and-use-the-installed-latest-sqlite3-ver

Essentially, you have to uninstall the (supposedly already installed) pysqlite2 adapter, download the sources, change some config file to enable the extension, rebuild and install it. Another thing: the sources pointed by the URL above did not compile okay, but I found the good ones at the sqlite website:

http://www.sqlite.org/download.html (first link)

Note: using easy_install to fetch the newest pysqlite2 is not going to work, it will not come with the amalgamation extension enabled.

jcchuang commented 10 years ago

As a workaround, removed fulltext search capabilities by default in 6cccbeb743addceefaaf519436b0e74ff4ee0e92