CODEWITHSUNDEEP
djangosqlitepython-3.3
Droid
Droid

Reputation: 1362

ImportError: No module named '_sqlite3' in python3.3

sqlite3 error

import sqlite3
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python3.3/sqlite3/__init__.py", line 23, in <module>
    from sqlite3.dbapi2 import *
  File "/usr/local/lib/python3.3/sqlite3/dbapi2.py", line 26, in <module>
    from _sqlite3 import *
ImportError: No module named '_sqlite3'

i use sqlite3 install command

pip install pysqlite
Downloading/unpacking pysqlite
  Downloading pysqlite-2.6.3.tar.gz (76kB): 76kB downloaded
  Running setup.py egg_info for package pysqlite
    Traceback (most recent call last):
      File "<string>", line 16, in <module>
      File "/usr/local/lib/python3.3/codecs.py", line 300, in decode
        (result, consumed) = self._buffer_decode(data, self.errors, final)
    UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe4 in position 98: invalid continuation byte 
    Complete output from command python setup.py egg_info:
    Traceback (most recent call last):

  File "<string>", line 16, in <module>

  File "/usr/local/lib/python3.3/codecs.py", line 300, in decode

    (result, consumed) = self._buffer_decode(data, self.errors, final)

UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe4 in position 98: invalid continuation byte

----------------------------------------
Cleaning up...
Command python setup.py egg_info failed with error code 1 in /tmp/pip_build_root/pysqlite
Storing complete log in /root/.pip/pip.log

Upvotes: 23

Views: 68096

Answers (6)

kalaivani
kalaivani

Reputation: 594

Follow the below url to get ride of this error, Centos-Sqlite3-Error-GCP

Upvotes: 0

wcc526
wcc526

Reputation: 4095

I think it must be you not install sqlite3, you can do like this

 sudo apt-get install sqlite3  
 sqlite3 -version  
 sudo apt-get install python-pysqlite2  
 sudo apt-get install python-pysqlite2-dbg  
 sudo apt-get install libsqlite3-dev   
 sudo apt-get install sqlite  
 sudo pip install pysqlite

then you will will find the sqlite3

Upvotes: 12

Amos Jianjun Kong
Amos Jianjun Kong

Reputation: 131

I touched this problem in using compiled 3.5.7

wget https://www.python.org/ftp/python/3.5.7/Python-3.5.7.tgz
tar xvfz Python-3.5.7.tgz
cd Python-3.5.7
./configure --enable-optimizations
sudo make altinstall

# python3.5
>>> import sqlite3
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python3.5/sqlite3/__init__.py", line 23, in <module>
    from sqlite3.dbapi2 import *
  File "/usr/local/lib/python3.5/sqlite3/dbapi2.py", line 27, in <module>
    from _sqlite3 import *
ImportError: No module named '_sqlite3'

Solution:

yum install sqlite-devel
re-compile python 3.5 from source

Upvotes: 3

R.Liu
R.Liu

Reputation: 371

For Python3 in Ubuntu:

  • sudo apt-get install libsqlite3-dev
  • wget https://www.python.org/ftp/python/3.6.3/Python-3.6.3.tar.xz (replace the version number by your python3 version)
  • tar -xf Python-3.6.3.tar.xz
  • cd Python-3.6.3/
  • ./configure --enable-loadable-sqlite-extensions && make && sudo make install

refer: https://github.com/sloria/TextBlob/issues/173

Upvotes: 9

陈 章
陈 章

Reputation: 81

The compile package is short of something,you should use yum to install these 5,and then recompile and install python3

yum install readline-devel
yum install tk-devel
yum install tcl-devel  
yum install openssl-devel   
yum install sqlite-devel

and then recompile the python3

tar Jxvf  Python-3.5.0.tar.xz
cd Python-3.5.0
./configure --prefix=/usr/local/python3
make && make install

Upvotes: 7

Anshul Bisht
Anshul Bisht

Reputation: 1654

I am a Fedora 20 user. To solve this:

  1. Install sqlite-devel package, using:

    yum install sqlite-devel

  2. After installing,recompile python from the source using:

    ./configure
make && make install

For multiple versions of Python, use altinstall instead of install.

Upvotes: 35

Related Questions