i have problem with pdo_sqlite

If you do

php -m

in your terminal do you see the extension sqlite3 and pdo_sqlite there?

@MCANGUEIRO - No pdo_sqlite doesnot exist but i installed php-sqlite3

how can i install this module

sudo apt-get install php-sqlite3

@SERGIU17 - I Did but it doesnot work php-sqlite3 is already the newest version (2:7.3+69+ubuntu18.04.1+deb.sury.org+2+php7.3)

@THESOGAFOI - Check your php.ini file if the extensions are enable

@SERGIU17 - i found i use php7.3 and i edit php.ini in etc/php/7.3/cli and enabled extension=pdo_sqlite And extension=sqlite3

still not work

@THESOGAFOI - that's frustrated, a while ago, I had the same problem, I installed everything related to sqlite, sqlite3, php-sqlite, php7-slqlte :D just everything)) And it was starting to work somehow, did you restart your service after installations? sudo service apache2 restart ?

etc/php/7.3/cli

You also need to enable it for the web version of PHP, in addition to the cli version. You only altered the cli version.

@SERGIU17 - I restart my valet And My nginx , it's so confusing :D‌

@CRONIX - i do it in my php.ini that located in etc/php/7.3/cli but not work

@THESOGAFOI - Cronix mean the apache not just the cli such as /etc/php/7.2/apache2/php.ini

or run the command to find it

php -i | grep "Loaded Configuration File"

@SIANGBOON - /etc/php/7.3/cli/php.ini its found here I turned on pdo_sqlite in php.ini but still not found

@THESOGAFOI - PHP CLI is not the same as the PHP Apache module...

https://superuser.com/questions/971867/why-is-the-php-version-different-in-phpinfo-and-cli

create a testing page and run the phpinfo() inside

<?php

phpinfo();

also in my phpinfo() see same version Loaded Configuration File /etc/php/7.4/cli/php.ini

ty all i do not know why and how but i fixed by using 2 commands

cd /usr/local/lib

sudo mv libsqlite3.so.0 ./libsqlite3.so.0.back

It works on my Ubuntu 18.04 (PHP 7.4) with these :

Before, I uncomment the extension=pdo_sqlite in php.ini file but nothing work. Then I installed php-sqlite3

sudo apt install php-sqlite3

Then, comment the extension=pdo_sqlite again in both /etc/php/7.4/cli/php.ini and /etc/php/7.4/apache2/php.ini then restart the server

sudo service apache2 restart

And finally it works

vendor/bin/phpunit

It sounds that your sqlite is built without the flag SQLITE_ENABLE_COLUMN_METADATA

• Docs for flag is here

When this C-preprocessor macro is defined, SQLite includes some additional APIs that provide convenient access to meta-data about tables and queries.

• It is also mentioned here

This enables some extra APIs that are required by some common systems, including Ruby-on-Rails.

... as well as aparently pdo_sqlite.so ^_^

Just purge linuxbrew sqlite and build from source. Keep OOB path suffixes....

sudo su
cd /usr/local/src
wget https://www.sqlite.org/2020/sqlite-autoconf-3330000.tar.gz
tar -xvzf sqlite-autoconf-3330000.tar.gz
cd sqlite-autoconf-3330000
CFLAGS="-O2 -DSQLITE_ENABLE_COLUMN_METADATA=1" ./configure
make
make install

Keep the /usr/local/src/sqlite-autoconf-3330000 so that you can make uninstall at any point.