Control Web Panel

WebPanel => Updates => Topic started by: srisree on April 02, 2021, 05:41:08 AM

Title: sqlite 3.26
Post by: srisree on April 02, 2021, 05:41:08 AM

how to update sqlite


i found sqlite in php.in editor. how to update or activate to 3.26 ( if i remove semicolon and save then it will be updated to 3.26?)


please guide me



[sqlite3]
; Directory pointing to SQLite3 extensions
; http://php.net/sqlite3.extension-dir
;sqlite3.extension_dir =
; SQLite defensive mode flag (only available from SQLite 3.26+)
; When the defensive flag is enabled, language features that allow ordinary
; SQL to deliberately corrupt the database file are disabled. This forbids
; writing directly to the schema, shadow tables (eg. FTS data tables), or
; the sqlite_dbpage virtual table.
; https://www.sqlite.org/c3ref/c_dbconfig_defensive.html
; (for older SQLite versions, this flag has no use)
;sqlite3.defensive = 1

Title: Re: sqlite 3.26
Post by: srisree on April 03, 2021, 02:57:21 AM

how to do update ? plz anyone

Title: Re: sqlite 3.26
Post by: srisree on April 06, 2021, 02:27:50 PM

waiting for reply.

any senior members?

Title: Re: sqlite 3.26
Post by: srisree on April 06, 2021, 02:47:10 PM

can i follow this

https://linuxhint.com/upgrade-to-latest-sqlite3-on-centos7/


please tell anyone

Title: Re: sqlite 3.26
Post by: Igor S. on April 07, 2021, 02:25:02 PM

Hi.

You can try to update it manually. Why not?

Title: Re: sqlite 3.26
Post by: srisree on April 08, 2021, 03:02:40 AM

How to update manually. Any guide or instructions. Plz guide me

Title: Re: sqlite 3.26
Post by: srisree on April 09, 2021, 06:24:44 PM

hello anyone?

Title: Re: sqlite 3.26
Post by: Sandeep on April 09, 2021, 10:33:48 PM

Hello you can install latest version by below procedure but we didn't tested it in php etc.

Code: [Select]

yum install tcl -y
cd /usr/local/src
wget https://www.sqlite.org/src/zip/bf8c1b2b/SQLite-bf8c1b2b.zip
unzip SQLite-bf8c1b2b.zip
cd SQLite-bf8c1b2b
./configure --prefix=/usr
make
make install


Title: Re: sqlite 3.26
Post by: srisree on April 12, 2021, 06:29:00 AM

installed perfect.

and rebooted

when i go to phpinfo still its showing 3.7.17

am i missing anything?

has to add anyhting to php.ini cnfiguraion ?

please guide me



[sqlite3]
; Directory pointing to SQLite3 extensions
; http://php.net/sqlite3.extension-dir
; sqlite3.extension_dir =

; SQLite defensive mode flag (only available from SQLite 3.26+)
; When the defensive flag is enabled, language features that allow ordinary
; SQL to deliberately corrupt the database file are disabled. This forbids
; writing directly to the schema, shadow tables (eg. FTS data tables), or
; the sqlite_dbpage virtual table.
; https://www.sqlite.org/c3ref/c_dbconfig_defensive.html
; (for older SQLite versions, this flag has no use)
;sqlite3.defensive = 1


plz guide me

Title: Re: sqlite 3.26
Post by: srisree on April 14, 2021, 11:59:21 AM

Please anyone

Title: Re: sqlite 3.26
Post by: srisree on April 16, 2021, 07:08:07 AM

Anyone?