PDO_SQLITE driver not present.. what to do?

Question

I see everywhere (including on the official docs) that the PDO_SQLITE driver is/should be included by default in PHP.

However, when I look at my extension_directory, I see only these files:

gd.so mcrypt.so mysqli.so mysql.so pdo_mysql.so pdo.so

And, as a result, a framework I'm trying to install (Symfony) tells me I need to install either the PDO_SQLITE or the SQLite3 .so extensions...

Can anyone help? Can I just try and find the needed .so file somewhere on the web, place it in my extensions_directory and then include it in php.ini??

BTW: I'm running php 5.3.6 downloaded via apt-get on ubuntu.

score 106 · Accepted Answer · edited May 13 '21 at 16:05

106

did you try sudo apt-get install php5-sqlite?

Current version: sudo apt install php7.4-sqlite

edited May 13 '21 at 16:05

Mark N Hopgood

843
8
14

answered Jan 11 '12 at 15:56

jere

4,306
2
27
38

3

I never cease to be amazed at just how simple linux is... Thanks for that.. Silly of me not to have thought of that first thing off. However. Shouldn't this SQLITE thing be available as default? – Felipe Jan 11 '12 at 16:03
you're welcome! according to the docs it should be. but in my fedora install i had to install it by hand, though it was strange because it was enabled in php.ini, but like you said the driver was not present anywhere... – jere Jan 11 '12 at 16:26
The sqlite module is availalbe after a PHP build from sources. But Linux distros often do their own thing. Most every module is available in their repositories - and most need to be explicitly installed. – DinoAmino Mar 09 '16 at 04:18
38

And for PHP7, you need to run: ``sudo apt-get install php7.0-sqlite3`` – Tahsin Abrar Apr 14 '16 at 04:17
Thanks worked fine for me with PHP 5.5.9-1ubuntu4.17 :-) – Ramesh Chand May 27 '16 at 06:42
9

**And for PHP 7.1**, you need to run: `sudo apt-get install php7.1-sqlite3` – Zanshin13 Mar 29 '17 at 14:39
14

**And of PHP 7.2**: `sudo apt-get install php7.2-sqlite3` – Vasily Bezruchkin Mar 29 '18 at 12:01
I think the above specifies the php 5 version, you will need to do something like this for the other greater php versions e.g. `sudo apt-get install php7.2-sqlite3` – Developer Kwame Jun 26 '19 at 23:28
Similarly for PHP 7.3 use sudo apt-get install php7.3-sqlite3 – Nish Jul 06 '19 at 20:13
3

for me `sudo apt-get install php-sqlite3` works fine with php 7.2 – Antoine Aïello Jul 16 '19 at 08:22
`php-sqlite3` should automatically update with `php`. – Mark Gardner Sep 01 '19 at 13:30
E: Couldn't find any package by regex 'php7.1-sqlite3' – Tajuddin Khandaker Sep 06 '19 at 15:56
Just so you know, `php5-sqlite` has been deleted from Ubunutu repositories. – Juha Untinen Apr 07 '20 at 22:21

score 31 · Answer 2 · answered Feb 20 '19 at 15:46

31

For PHP 7.0 and greater:

sudo apt-get install php-sqlite3

answered Feb 20 '19 at 15:46

Santo Boldizar

1,255
14
17

1

Or sudo apt-get install php7.X-sqlite , where X is the correponding number of of your fpm – PHPer Aug 10 '19 at 02:36
1

E: Unable to locate package php-sqlite3 – Tajuddin Khandaker Sep 06 '19 at 15:54
1

It's ok to add you php version but you still need to add the 3 after sqlite – SpicyTacos23 Oct 07 '19 at 06:36

score 8 · Answer 3 · edited May 08 '18 at 10:29

8

For Windows users:

removed comment (;) from php.ini

extension=php_pdo_sqlite.dll

extension=php_sqlite3.dll

edited May 08 '18 at 10:29

Syscall

19,327
10
37
52

answered May 08 '18 at 10:18

Mohammed Saqib Rajput

1,331
1
14
22

score 5 · Answer 4 · answered Jun 13 '19 at 08:48

5

In my case i was using php 7.2 in Ubuntu. I had to run following command,

sudo apt install php7.2-sqlite

answered Jun 13 '19 at 08:48

sh6210

4,190
1
37
27

2

E: Couldn't find any package by regex 'php7.2-sqlite' – Tajuddin Khandaker Sep 06 '19 at 15:55

score 1 · Answer 5 · answered Feb 07 '19 at 14:54

1

For Windows 10 - 64bits, version PHP 7.2 It's necessary remove only ( ; ) Before ;extension=pdo_sqlite ;extension=sqlite3

After extension=pdo_sqlite extension=sqlite3

Restart the server and already.

answered Feb 07 '19 at 14:54

rui

11
2

Not universally. 7.3.9 works; 7.4.14 not so much. Same for the Rajput (above) 'solution.' – Cuse70 Jan 07 '21 at 07:42

score 1 · Answer 6 · answered Apr 07 '23 at 10:38

1

For PHP 8.1.2

sudo apt install php8.1-sqlite3

answered Apr 07 '23 at 10:38

Nauman Bashir

101
1
7

Thanks! And unsurprisingly, for php 8.2 it's `apt install php8.2-sqlite3` :) – Tomasz Cz. Apr 19 '23 at 19:36

PDO_SQLITE driver not present.. what to do?

6 Answers6

Linked