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

Question

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

python manage.py syncdb Traceback (most recent call last): File "/usr/local/lib/python3.3/site-packages/django/db/backends/sqlite3/base.py", line 29, in — Droid, Nov 21 '13 at 16:42
What platform? Do you have sqlite3 otherwise installed, say with homebrew or apt? — StevenC, Jan 01 '14 at 20:41
Follow below steps 1) wget https://www.sqlite.org/2020/sqlite-autoconf-3310100.tar.gz 2) tar xvf sqlite-autoconf-3310100.tar.gz 3) cd sqlite-autoconf-3310100/ 4) ./configure --prefix=/usr 5) make install 6) Re-compile Python 3.X.X. Be sure run "make clean" before "make install" if you've already installed — ashwin, Aug 27 '20 at 09:57

score 35 · Answer 1 · edited Sep 08 '14 at 10:20

35

I am a Fedora 20 user. To solve this:

Install sqlite-devel package, using:
```
yum install sqlite-devel
```
After installing,recompile python from the source using:
```
./configure
make && make install
```

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

edited Sep 08 '14 at 10:20

Arman H

5,488
10
51
76

answered Sep 08 '14 at 09:59

Anshul Bisht

1,644
20
21

2

I have no idea why this got two downvotes. It solved the problem on CentOS 5.11. – 1'' Jan 07 '15 at 02:59
7

Where is the configure file? I've tried `find /*/python*/conf*` but found nothing. – Andreas Jan 04 '16 at 10:11
This is a great answer. Just worked for me on RHEL 6.7 (Santiago). – gr1zzly be4r May 31 '16 at 16:02
reasonable answer! Worked on the CentOS 7! – Soheil Pourbafrani Oct 23 '19 at 19:02

score 12 · Answer 2 · edited Jun 15 '20 at 06:13

12

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

edited Jun 15 '20 at 06:13

Community

1
1

answered Feb 20 '14 at 13:54

wcc526

3,915
2
31
29

This worked for me : https://www.markgruenberg.site/doku.php?id=python:sqlite3_not_installed_on_python_centos_or_rhat – Krishna Shetty Sep 17 '19 at 07:10
Thanks, `libsqlite3-dev` is the missing key for me. – Itachi Feb 26 '20 at 17:53
I don't understand what sorcery is this but it does work ! – attaboyabhipro Dec 02 '21 at 06:31

score 9 · Answer 3 · answered Sep 12 '18 at 03:54

9

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

answered Sep 12 '18 at 03:54

R.Liu

361
3
6

2

Beware that "make install" is not recommended as it may overwrite your system's Python version and some packages might depend on specific versions. It is recommended to use "make altinstall" to not overwrite /usr/bin/python3 but install it into /usr/local/bin/python3. See https://docs.python.org/3.7/using/unix.html#building-python for details! – macskay Oct 02 '19 at 14:03

score 7 · Answer 4 · answered Aug 12 '16 at 07:48

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

Amos Jianjun Kong · Answer 5 · 2019-06-05T19:18:07.620

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

I installed sqlite-devel before second recompile, this might solve the problem. `yum install sqlite-devel` — Amos Jianjun Kong, Jun 05 '19 at 19:15

score 0 · Answer 6 · answered Oct 10 '22 at 07:13

0

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

answered Oct 10 '22 at 07:13

kalaivani

484
1
5
8

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

6 Answers6

Solution:

Linked

Related