ImproperlyConfigured('SQLite 3.8.3 or later is required (found %s).' % Database.sqlite_version)

Question

ImproperlyConfigured('SQLite 3.8.3 or later is required (found %s).' % Database.sqlite_version) django.core.exceptions.ImproperlyConfigured: SQLite 3.8.3 or later

I met with this problem at the django project, mismatching version for the sqlite3 and the django. this occurs at the centos7 env, and I also want a convenient solution that works in the container env.

score 6 · Answer 1 · edited Sep 17 '21 at 13:05

I solved this issue by upgrading my version of sqlite3 using this command:

cd ~ && wget https://www.sqlite.org/2020/sqlite-autoconf-3320100.tar.gz && tar xvfz sqlite-autoconf-3320100.tar.gz && cd sqlite-autoconf-3320100 && ./configure && make && make install

I am using ElasticBeanstalk for my setup, so I added a .config file to the .ebextensions folder and put this in it:

option_settings:
  aws:elasticbeanstalk:application:environment:
    LD_LIBRARY_PATH: "/usr/local/lib"
commands:
  01_upgrade_sqlite:
    command: "cd ~ && wget https://www.sqlite.org/2020/sqlite-autoconf-3320100.tar.gz && tar xvfz sqlite-autoconf-3320100.tar.gz && cd sqlite-autoconf-3320100 && ./configure && make && make install"

Many thanks to Bejür for adding the LD_LIBRARY_PATH environment variable here in order to get it to work.

score 1 · Answer 2 · edited Sep 16 '21 at 13:54

1

In my case, upgrading sqlite with kloddant's instructions helped only partially. SQLite was installed, but python was still referring to the old sqlite version.

An additional step to fix this issue was setting the environment variable LD_LIBRARY_PATH="/usr/local/lib"

Add it to .ebextensions/*.config

option_settings:
  "aws:elasticbeanstalk:application:environment":
    LD_LIBRARY_PATH: "/usr/local/lib"

edited Sep 16 '21 at 13:54

kloddant

1,026
12
19

answered Apr 01 '21 at 11:14

Bejür

110
2
7

Did this really work? I've tried this as well as adding a command `command: export LD_LIBRARY_PATH=/usr/local/lib`, but I keep getting the error `deterministic=True requires SQLite 3.8.3 or higher`. – Berco Beute Apr 16 '21 at 21:54
Something must have changed with Elastic Beanstalk. My answer worked back then, but now it stopped working until I added this bit from you. Thank you so much! I'll incorporate your answer into mine for future viewers. – kloddant Sep 15 '21 at 17:32

score -1 · Answer 3 · answered Mar 24 '20 at 07:50

-1

You have an outdated version of SQLite,you can try this:

python -m pip install -U sqlite

answered Mar 24 '20 at 07:50

xkcdjerry

965
4
15

I’m sorry I tried, but this doesn't work wor me. thanks all the same. – imissyou Mar 24 '20 at 08:23

score -4 · Answer 4 · answered Mar 24 '20 at 08:18

-4

I now find a usable solution: change the version of Django from 'Django==3.0.4' to 'Django==2.1.8' and it worked.

pip install django==2.1.8 -i https://mirrors.aliyun.com/pypi/simple/

answered Mar 24 '20 at 08:18

imissyou

123
2
5

1

Downgrading Django, while it might work, is not really a great option and is at best a short-term fix. – kloddant Jun 02 '20 at 15:03
It‘s not, but with time restriction. Expect your superior solution. – imissyou Jul 09 '20 at 06:34
I've posted it. However, if I had not found a way, I would recommend using a conventional database instead of sqlite. – kloddant Jul 09 '20 at 13:33

ImproperlyConfigured('SQLite 3.8.3 or later is required (found %s).' % Database.sqlite_version)

4 Answers4

Linked