Thursday, May 2, 2024
11
rated 0 times [  11] [ 0]  / answers: 1 / hits: 10280  / 1 Year ago, sat, may 20, 2023, 8:11:51

I had the Ubuntu repositories of SQLite3 with v3.7.17. But it doesn't have the .save command as newer versions.



To update I did:




  1. sudo apt-get purge sqlite3

  2. Download SQLite 3.8.4.3

  3. Install it with ./configure && make && sudo make install



But now when I try to run sqlite3 from command line I get:



SQLite header and source version mismatch
2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668
2014-04-03 16:53:12 a611fa96c4a848614efe899130359c9f6fb889c3


Searching I found two solutions that I've tried without success:




  • This answer didn't work because I don't have sqlite on /usr/bin

  • This solution didn't work neither, but I did backup to revert those useless changes.



Any idea of how to solve this error?


More From » software-installation

 Answers
2

After building from source, your v3.8.4.3 version is now installed in /usr/local/lib.



You need to replace /usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6 (or /usr/lib/i386-linux-gnu/libsqlite3.so.0.8.6 for i386 arch) with the one from /usr/local/lib:



sudo cp /usr/local/lib/libsqlite3.so.0.8.6 /usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6

[#26194] Sunday, May 21, 2023, 1 Year  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
skaing

Total Points: 462
Total Questions: 124
Total Answers: 113

Location: Nauru
Member since Thu, Feb 2, 2023
1 Year ago
skaing questions
;