問題:django.core.exceptions.ImproperlyConfigured: SQLite 3.8.3 or later is required (found 3.7.17).
解決辦法:
- 查看當前SQLite3版本:
[root@iZwz906mxhbe3mpxy6kyzoZ myblog-python]# sqlite3 --version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668
2.如果用了虛擬環(huán)境鹏控,查看運行環(huán)境中的SQLite3版本
[root@iZwz906mxhbe3mpxy6kyzoZ myblog-python]# workon blog
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ myblog-python]# python3
Python 3.6.5 (default, Nov 8 2019, 11:56:20)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-39)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.sqlite_version
'3.7.17'
>>> exit()
- Centos7安裝最新的sqlite3并設(shè)置更新python庫版本
#回到根目錄
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ myblog-python]# cd ~
#下載
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# wget https://www.sqlite.org/2019/sqlite-autoconf-3270200.tar.gz
#解壓
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# tar -zxvf sqlite-autoconf-3270200.tar.gz
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# cd sqlite-autoconf-3270200
#配置安裝路徑
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ sqlite-autoconf-3270200]# ./configure --prefix=/usr/local
#安裝
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ sqlite-autoconf-3270200]# make && make install
#查找SQLite3的路徑
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ sqlite-autoconf-3270200]# find /usr/ -name sqlite3
#將下載解壓的文件全刪除
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ sqlite-autoconf-3270200]# cd ~
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# rm -rf sqlite-autoconf-3270200
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# rm -rf sqlite-autoconf-3270200.tar.gz
#檢查版本
## 最新安裝的sqlite3版本
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# /usr/local/bin/sqlite3 --version
3.27.2 2019-02-25 16:06:06 bd49a8271d650fa89e446b42e513b595a717b9212c91dd384aab871fc1d0f6d7
## Centos7自帶的sqlite3版本
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# /usr/bin/sqlite3 --version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668
## 運行環(huán)境的sqlite3版本
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# sqlite3 --version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668
## 更改舊的sqlite3
### 備份舊的sqlite3
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# mv /usr/bin/sqlite3 /usr/bin/sqlite3_old
## 將新的sqlite3軟連接到原來sqlite3位置
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# ln -s /usr/local/bin/sqlite3 /usr/bin/sqlite3
## 運行環(huán)境的sqlite3版本
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# sqlite3 --version
3.27.2 2019-02-25 16:06:06 bd49a8271d650fa89e446b42e513b595a717b9212c91dd384aab871fc1d0f6d7
#將路徑傳遞給共享庫
# 設(shè)置開機自啟動執(zhí)行湾盒,可以將下面的export語句寫入 ~/.bashrc 文件中盼樟,如果如果你想立即生效得运,可以執(zhí)行source ?/.bashrc 將在每次啟動終端時執(zhí)行
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# export LD_LIBRARY_PATH="/usr/local/lib"
# 檢查Python的SQLite3版本
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ ~]# python3
Python 3.6.5 (default, Nov 8 2019, 11:56:20)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-39)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.sqlite_version
'3.27.2'
>>> exit
Use exit() or Ctrl-D (i.e. EOF) to exit
>>> exit()
# 執(zhí)行項目
(blog) [root@iZwz906mxhbe3mpxy6kyzoZ myblog-python]# python manage.py runserver
INFO 2019-11-09 10:27:55,169 autoreload 597 Watching for file changes with StatReloader
Performing system checks...
System check identified no issues (0 silenced).
November 09, 2019 - 10:27:55
Django version 2.2.5, using settings 'myblog.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CONTROL-C.