Level 73
Check this guide out, it might contain some information that will help you.
https://www.digitalocean.com/community/tutorials/how-to-install-and-use-sqlite-on-ubuntu-20-04
Sep 6, 2022
19
Level 2
Issue with SQLite version
Hi! I had SQLite v3.31 on Ubuntu v20.04. Than I removed SQLite v3.31 and install SQLite v3.34. But my Laravel application continue using SQLite v3.31. Than I removed my old local.db file and create new one. It was not help - app continue uses SQLite v3.31.
For check version I use this script - "select sqlite_version()". I don't have any idea why I have this issue. Can you help me please?
Level 2
@Tray2 Thanks! But is not what I need) Already used that article for first installation.
Level 73
@ILikeDARts Have you rebooted since the updgrade?
What does which sqlite3 give you and what does sqlite3 --version give you?
Level 2
@Tray2 Yeah, I reboot server.
In bash I have v3.34 - https://imgur.com/a/6YhjQ2L
In app I have v3.31 - https://imgur.com/a/6YhjQ2L
Level 73
@ILikeDARts Have you tried clearing the cache in laravel?
Level 102
@ILikeDARts Which php version?
Level 2
@Tray2 yeap
Level 2
@Sinnbeck v8.1.9
Level 102
@ILikeDARts Did you try
sudo apt install php8.1-sqlite3
Level 2
Level 2
@Sinnbeck I find this - https://imgur.com/a/iWYk0ih
Can I change this in config?
Level 102
@ILikeDARts That should be what sudo apt install php8.1-sqlite3 should do. Any chance your server does not use the ondrej PPA?
sudo add-apt-repository ppa:ondrej/php
sudo apt update
sudo apt upgrade
Level 2
@Sinnbeck I did it. Than after rebooting server I had this issue - https://imgur.com/a/NNPHgSC
I fix issue using this post - https://laracasts.com/discuss/channels/laravel/i-have-problem-with-pdo-sqlite
Than I reboot server and saw this - https://imgur.com/a/NNPHgSC
Level 102
@ILikeDARts So its missing now?
sudo apt install php8.1-sqlite3
Level 2
@Sinnbeck no, its still intalled
Level 102
@ILikeDARts From the error it looks it it isnt working.
sudo apt purge php8.1-sqlite3
sudo apt install php8.1-sqlite3
Level 2
@Sinnbeck I did it and reboot server - https://imgur.com/a/2aHkPZw
Level 102
@ILikeDARts Then I am unsure. I have the latest version using the ondrej ppa.
Level 2
Also, I think you need to know)
Locally I have Windows with SQLite v3.36 and all work fine)
Please or to participate in this conversation.