PHP Fatal error: Class 'PDO' not found

Question

PHP Fatal error:  Class 'PDO' not found in /home/bd/public_html/app/webroot/Cake/Model/Datasource/Database/Mysql.php on line 177

PHP INFO:

PDO

PDO support => enabled
PDO drivers => sqlite, sqlite2, mysql

pdo_mysql

PDO Driver for MySQL => enabled
Client API version => 5.5.24

Directive => Local Value => Master Value
pdo_mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock

pdo_sqlite

PDO Driver for SQLite 3.x => enabled
SQLite Library => 3.7.7.1

PHP INI:

extension=pdo.so
extension=pdo_sqlite.so
extension=sqlite.so
extension=pdo_mysql.so

CODE:

/**
 * Check whether the MySQL extension is installed/loaded
 *
 * @return boolean
 */
        public function enabled() {
                return in_array('mysql', PDO::getAvailableDrivers());
        }

Ideas as to why I'm getting this error?

PHP 5.3.15 CloudLinux/CentOS 6 CPanel

"Debug setting does not allow access to this url" added that to it's own php file and ran it. — Amanada Smith, Aug 05 '12 at 02:06
how did you obtain the php_info output? if you did it from the CLI the output may be different as cPanel uses a separate PHP binary to the CentOS one. — Geoffrey, Aug 05 '12 at 02:29
has your setup worked before? did you make changes? can you provide some details on what you did to end up with this? and if not too much maybe show the output of `phpinfo();` from CLI and from browser. — Czar Pino, Aug 05 '12 at 04:24
Never worked with a script that needed PDO before. Was installing it and noticed it used PDO it looks like. — Amanada Smith, Aug 05 '12 at 12:40
I have the same problem. Did you solve this? it may help me too — YahyaE, Dec 15 '15 at 01:34

score 76 · Answer 1 · edited Nov 08 '16 at 08:22

76

try

 yum install php-pdo
 yum install php-pdo_mysql

 service httpd restart

edited Nov 08 '16 at 08:22

sj59

2,072
3
22
23

answered May 10 '13 at 04:04

Nam Nguyen

2,438
21
18

3

@s4suryapal: run it in console command line of server linux. On window, you can uncommend line with: extension=php_pdo_mysql.dll in php.ini (ex: xampp, wamp, ...) and restart apache – Nam Nguyen Nov 18 '14 at 18:06
the question meant he has pdo installed (quote from phpinfo), so -1. – Putnik Aug 19 '16 at 19:25
How do i install php pdo for oracle on cent os 5.8 ? – Sanjay Rao Dec 01 '16 at 18:30

score 75 · Answer 2 · answered Jul 05 '14 at 15:54

75

Try adding use PDO; after your namespace or just before your class or at the top of your PHP file.

answered Jul 05 '14 at 15:54

Jo Smo

6,923
9
47
67

6

That did it for me... I was inside a namespaced class, and simply adding a ` \ ` in front of `PDO` as suggested elsewhere didn't work - but this did :) – erlingormar Jan 25 '15 at 13:29
Question didn't mention he was using namespace. if some one use namespace for all other customer classes this should be the acceptable answer. Because somewhare in the code he missed `use PDO` Otherwise need to install correct PDO version libraries into their webserver. – Elshan Oct 27 '19 at 15:09
This helped me out a bunch. Thank you. This works too if anybody wonders because PDO is a global class within PHP. – wowzuzz Oct 02 '20 at 20:07

score 22 · Answer 3 · edited Jan 19 '17 at 23:17

22

This can also happen if there is a php.ini file in the web app's current working directory. If one has been placed there to change certain settings, it will override the global one.

To avoid this problem, don't use a php.ini file to change settings; instead you can:

Specify settings in the vhost declaration
Use an .htaccess file with php_flag (see here)
Use an .user.ini file (see here)

edited Jan 19 '17 at 23:17

Simon East

55,742
17
139
133

answered Mar 07 '13 at 06:39

Alastair Irvine

1,166
12
16

Hi Alastair, I expanded your answer slightly. Hope that's OK. ;-) – Simon East Jan 19 '17 at 23:18
Can you give an example of how to add pdo in .htaccess please? Thank you! – erol yeniaras May 06 '20 at 23:36

score 15 · Answer 4 · answered Jan 02 '15 at 19:16

Ensure they are being called in the php.ini file

If the PDO is displayed in the list of currently installed php modules, you will want to check the php.ini file in the relevant folder to ensure they are being called. Somewhere in the php.ini file you should see the following:

extension=pdo.so
extension=pdo_sqlite.so
extension=pdo_mysql.so
extension=sqlite.so

If they are not present, simply add the lines above to the bottom of the php.ini file and save it.

score 10 · Answer 5 · answered Aug 06 '12 at 05:35

10

What is the full source of the file Mysql.php. Based on the output of the php info list, it sounds like you may be trying to reference a global class from within a namespace.

If the file Mysql.php has a statement "namespace " in it, use \PDO in place of PDO - this will tell PHP to look for a global class, rather than looking in the local namespace.

answered Aug 06 '12 at 05:35

Stephen

18,597
4
32
33

well no namespaces there, I'm stumped again. – Stephen Aug 06 '12 at 12:58
I'm just wondering if maybe this is a poorly coded script. I had to actually move the Cake framework into the webroot directory just to even get this far ;/ script is: http://www.freereviewscript.com/p/requirements – Amanada Smith Aug 06 '12 at 13:41

Ikhlak S. · Answer 6 · 2016-06-25T12:34:06.327

3

I had the same problem on GoDaddy. I added the extension=pdo.so to php.ini, still didn't work. And then only one thing came to my mind: Permissions

Before uploading the file, kill all PHP processes(cPanel->PHP Processes).

The problem was that with the file permissions, it was set to 0644 and was not executable . You need to set the file permission at least 0755.

edited Jun 25 '16 at 12:34

answered Jun 25 '16 at 11:37

Ikhlak S.

8,578
10
57
77

score 3 · Answer 7 · answered Apr 23 '19 at 17:23

you can just find-out loaded config file by executing below command,

 php -i | grep 'php.ini'

Then add below lines to correct php.ini file

extension=pdo.so
extension=pdo_sqlite.so
extension=pdo_mysql.so
extension=sqlite.so

Then restart web server,

service httpd restart

score 3 · Answer 8 · edited Mar 19 '20 at 19:59

3

Its a Little Late but I found the same problem and i fixed it by a "\" in front of PDO

public function enabled() {
    return in_array('mysql', \PDO::getAvailableDrivers());
}

edited Mar 19 '20 at 19:59

Dharman

30,962
25
85
135

answered Mar 19 '20 at 19:46

Wells

142
1
13

you can use multi_query for what you described (https://stackoverflow.com/a/22469722/2943403), but you shouldn't. `multi_query()` does not allow parameterization. Use a single prepared statement with looped executions and grab the new ids as you go. – mickmackusa Dec 03 '20 at 11:58
Adapt this: https://stackoverflow.com/a/25939954/2943403 to get the new ids let me know when you've read these comments so that I can delete them. – mickmackusa Dec 03 '20 at 12:06

score 1 · Answer 9 · answered Aug 06 '12 at 05:29

1

This error is caused by PDO not being available to PHP.

If you are getting the error on the command line, or not via the same interface your website uses for PHP, you are potentially invoking a different version of PHP, or utlising a different php.ini configuration file when checking phpinfo().

Ensure PDO is loaded, and the PDO drivers for your database are also loaded.

answered Aug 06 '12 at 05:29

Predominant

1,460
12
24

It is loaded as mentioned in comments above. – Amanada Smith Aug 06 '12 at 11:57
2

+10 That's so ridiculous to vote down...it's exactly what happens with me..after upgrading PHP to 7.1 PDO not available...some downvoters really weird. is this kind of a hobby in the stack? – wpcoder Oct 29 '17 at 09:56
1

I think a lot of people don't realize this site is a resource for everyone, not just OP. Not every answer will be _specifically_ of use to OP, but that doesn't mean they will be of no use to others. This one was the clue I needed, for instance. Upvoted. Cheers. – Phil Dec 18 '18 at 10:57

score 1 · Answer 10 · answered Nov 26 '21 at 19:46

1

For Fedora 33 you can install as follows:

Install

dnf install php-pdo
dnf install php-pdo_mysql

Restart PHP

systemctl restart php-fpm.service

answered Nov 26 '21 at 19:46

Aris

4,643
1
41
38

It works!! After adding Remi repo of course. Great! Thank You! :) After several years with Ubuntu and apt it is hard to use Yum. – Sergey Serov Jun 25 '22 at 19:32
Note: It is necessary to run commands with `sudo` – Sergey Serov Jun 25 '22 at 19:48
yes you need sudo, I run them under the root user. – Aris Jun 27 '22 at 05:35

score 0 · Answer 11 · answered Nov 04 '15 at 13:58

0

I solved it with library PHP_PDO , because my hosting provider didn't accept my requirement for installation of PDO driver to apache server.

answered Nov 04 '15 at 13:58

Pavel Hájek

176
1
8

Hi, can you guide me how to add library to cpanel because I am on shared hosting and stuck in this. – Ramesh Kumar Apr 30 '16 at 08:27
Thanks bro you are awesome. Working PDO... :) – Ramesh Kumar Apr 30 '16 at 09:09
Hi, can you guide me how to add library to cpanel because I am on shared hosting ! – Ayed Mohamed Amine May 25 '16 at 11:23
1

Ramesh Kumar : just include PHP_PDO to beginning your exists code – Pavel Hájek May 26 '16 at 16:13

score -1 · Answer 12 · answered Jan 25 '19 at 06:43

-1

If you run php with php-fpm module,do not forget to run command systemctl restart php-fpm!That will reload php-fpm module.

answered Jan 25 '19 at 06:43

user10965860

1

It is looking like a comment and does not provide the answer at all to the answer at all. – Suraj Kumar Jan 25 '19 at 06:49

score -1 · Answer 13 · answered Dec 06 '20 at 15:20

-1

I had to run the following on AWS EC2 Linux instance (PHP Version 7.3):

sudo yum install php73-php-pdo php73-php-mysqlnd

answered Dec 06 '20 at 15:20

Justin

901
8
11

score -1 · Answer 14 · edited Nov 29 '21 at 23:08

-1

If anyone getting this error in cPanel, please check the PHP version type in your cPanel. Change it, alt-php to ea-php. This setting worked for me.

edited Nov 29 '21 at 23:08

Dharman

30,962
25
85
135

answered Sep 07 '21 at 06:20

Mozammel Hoque Nasif

1
1

score -1 · Answer 15 · answered Sep 09 '21 at 03:41

-1

After a long time, I finally solved it. check your folder in Cpanel to see if there is a php.ini file. if yes delete it since Cpanel will be using its own php.ini

answered Sep 09 '21 at 03:41

Justice Selorm Bruce

220
4
8

PHP Fatal error: Class 'PDO' not found

15 Answers15

Linked

Related