I need the latest version of Sqlite3 on PHP 7.3.

leonidukg

• February 22, 2020 05:05

Hello. I need the latest version of Sqlite3 on PHP 7.3. But EasyApache 4 always compiles without-sqlite3 and the system Sqlite 3.7.17 version is installed. There are no options for selecting sqlite3 in EasyApache. How can I compile PHP 7.3 with the new version of Sqlite3 ?

• 

  cPanelLauren

  • February 24, 2020 20:24

  Hello, The package cpanel-sqlite is using version 3.27.1: cpanel-sqlite-3.27.1-1.cp1186.x86_64 /usr/local/cpanel/3rdparty/bin/sqlite3 --version 3.27.1 2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959a1dd
  Beyond that though, the only SQLite3 versions available would be what is provided by the operating system. There is no PHP version specific version of SQLite3.

  0
• 

  keatliang2005

  • September 20, 2022 14:07

  I have notice with the latest php80 and php81 the sqlite3 build version of very old Psy Shell v0.11.8 (PHP 8.1.10 " cli) by Justin Hileman >>> $dbh = new PDO('sqlite::memory:'); => PDO {#4956 inTransaction: false, attributes: { CASE: NATURAL, ERRMODE: EXCEPTION, PERSISTENT: false, DRIVER_NAME: "sqlite", ORACLE_NULLS: NATURAL, CLIENT_VERSION: "3.7.17", SERVER_VERSION: "3.7.17", STATEMENT_CLASS: [ "PDOStatement", ], DEFAULT_FETCH_MODE: BOTH, }, } as with current sqlite version are 3.39.3 and many other package using newer syntax with 3.7.17 it will break with newer library such as doctrine/dbal v3 because generated SQL syntax is not support at 3.7.17 can you guys update the base install of the sqlite for the php build ? ./configure '--with-pdo-sqlite=shared,/usr' '--with-sqlite3=shared,/usr'

  0
• 

  Arshad Hussain

  • November 27, 2022 09:50

  Hi, I also need the latest version of sqlite3. Without this, one of my sites is in error state since 2020. Please do the needfull.

  0
• 

  rbairwell

  • November 27, 2022 13:19

  Just to correct @cPanelLauren , yes /usr/local/cpanel/3rdparty/bin/sqlite3 --version
  (which returns 3.38.5 on my Centos v7.9.2009 server running cPanel 108.0.4), that is a cPanel specific package which won't respond to the standard "sqlite3" command (due to path settings for user accounts) and, tbh, I'm not sure how users are meant to be aware of it) and is intended for use by the cPanel system itself (for example, using RoundCube). The "default location" for sqlite3 is /usr/bin/sqlite3
  which is version 3.7.17 (2013-05-20) on my machine. Doing a quick repoquery -i sqlite
  shows that this version was found on the CentOS-base repo, Checking that repository for has a guide) or upgrade your operating system. AlmaLinux 9 has SQLite 3.34.1-5, CentOS 9 Stream has 3.34-5 and Ubuntu 22.04 has 3.37.2-2 (all according to

  0

Please sign in to leave a comment.