sqlite3.OperationalError: no such module: fts5

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

sqlite3.OperationalError: no such module: fts5

Moslem
This post was updated on .
Hi
my error in UMLS import is :

"""

* Owlready2 * Warning: optimized Cython parser module 'owlready2_optimized' is not available, defaulting to slower Python implementation
Importing UMLS from Zip file 2018AB-full/2018ab-1-meta.nlm...
  Parsing 2018AB/META/MRRANK.RRF.gz as MRRANK...
  Parsing 2018AB/META/MRCONSO.RRF.aa.gz as MRCONSO...
  Parsing 2018AB/META/MRCONSO.RRF.ab.gz as MRCONSO...
  Parsing 2018AB/META/MRDEF.RRF.gz as MRDEF...
Importing UMLS from Zip file 2018AB-full/2018ab-2-meta.nlm...
  Parsing 2018AB/META/MRREL.RRF.aa.gz as MRREL...
  Parsing 2018AB/META/MRREL.RRF.ab.gz as MRREL...
  Parsing 2018AB/META/MRREL.RRF.ac.gz as MRREL...
  Parsing 2018AB/META/MRREL.RRF.ad.gz as MRREL...
  Parsing 2018AB/META/MRREL.RRF.ae.gz as MRREL...
  Parsing 2018AB/META/MRSAT.RRF.aa.gz as MRSAT...
  Parsing 2018AB/META/MRSAT.RRF.ab.gz as MRSAT...
  Parsing 2018AB/META/MRSAT.RRF.ac.gz as MRSAT...
  Parsing 2018AB/META/MRSAT.RRF.ad.gz as MRSAT...
  Parsing 2018AB/META/MRSAT.RRF.ae.gz as MRSAT...
Breaking ORIG cycles...
    SNOMEDCT_US : 0 cycles found:
    ICD10 : 0 cycles found:
    SRC : 0 cycles found:
Finalizing only properties and restrictions...
Finalizing CUI - ORIG mapping...
Indexing...
FTS Indexing...
Traceback (most recent call last):
  File "/home/nikvand/ReportProcess/test.py", line 5, in <module>
    import_umls("umls-2018AB-full.zip", terminologies = ["ICD10", "SNOMEDCT_US", "CUI"])
  File "/home/nikvand/ReportProcess2/lib/python3.7/site-packages/owlready2/pymedtermino2/umls.py", line 699, in import_umls
    default_world.full_text_search_properties.append(label)
  File "/home/nikvand/ReportProcess2/lib/python3.7/site-packages/owlready2/util.py", line 76, in append
    def append(self, x):          old = list(self); super().append(x)         ; self._callback(self._obj, old)
  File "/home/nikvand/ReportProcess2/lib/python3.7/site-packages/owlready2/namespace.py", line 431, in _full_text_search_changed
    self.graph.enable_full_text_search(Prop.storid)
  File "/home/nikvand/ReportProcess2/lib/python3.7/site-packages/owlready2/triplelite.py", line 971, in enable_full_text_search
    self.execute("""CREATE VIRTUAL TABLE fts_%s USING fts5(s UNINDEXED, o, d UNINDEXED, content=datas, content_rowid=rowid)""" % prop_storid)

sqlite3.OperationalError: no such module: fts5

On Tue, May 28, 2019 at 7:43 AM Moslem Samiee <moslemsamiee@gmail.com> wrote:
sqlite3.OperationalError: no such module: fts5

"""


can you help me please ?
thanks
Reply | Threaded
Open this post in threaded view
|

Re: sqlite3.OperationalError: no such module: fts5

Jiba
Administrator
Hi,

It seems that your version of Python do not have SQLite with FTS (Full-Text-Search) support.

Under Linux, SQLite can be a shared library, so you should update Python but also SQLite3.

Jiba
Reply | Threaded
Open this post in threaded view
|

Re: sqlite3.OperationalError: no such module: fts5

Moslem
hi Jiba
thanks  a lot 

On Wed, May 29, 2019 at 2:40 PM Jiba [via Owlready] <[hidden email]> wrote:
Hi,

It seems that your version of Python do not have SQLite with FTS (Full-Text-Search) support.

Under Linux, SQLite can be a shared library, so you should update Python but also SQLite3.

Jiba


If you reply to this email, your message will be added to the discussion below:
http://owlready.8326.n8.nabble.com/sqlite3-OperationalError-no-such-module-fts5-tp1103p1106.html
To unsubscribe from sqlite3.OperationalError: no such module: fts5, click here.
NAML