Drupal 7: PHP fatal error 'Undefined class constant MYSQL_ATTR_USE_BUFFERED_QUERY' when trying to install on MySQL database

By Konstantin Boyandin on 6 Jan 2011 at 02:15 UTC

Hello,

I am trying to install Drupal 7 locally, and it faiuls when I try to provide MySQL data:

- the ditribution is unpacked, sites/default is made writable by Web server, sites/default/files is created and made writable by Web server
- the http://example.com is loaded and installation starts

On step 3, when I copy sites/default/default.settings.php to sites/default/settings.php (Drupal doesn't do that, even though the directory is Web server writable), I am only offered SQLite engine choice.

When I manually add MySQL data, the installation fails with PHP fatal error. The trace is in the end of posting.

So, in short, is it really possible to install Drupal 7 on MySQL database? How it is done?

[06-Jan-2011 08:02:50] PHP Fatal error: Undefined class constant 'MYSQL_ATTR_USE_BUFFERED_QUERY' in /local/www/example.com/includes/database/mysql/database.inc on line 43
[06-Jan-2011 08:02:50] PHP Stack trace:
[06-Jan-2011 08:02:50] PHP 1. {main}() /local/www/example.com/install.php:0
[06-Jan-2011 08:02:50] PHP 2. install_drupal($settings = *uninitialized*) /local/www/example.com/install.php:27
[06-Jan-2011 08:02:50] PHP 3. install_run_tasks($install_state = array ('interactive' => TRUE, 'active_task' => 'install_verify_requirements', 'completed_task' => NULL, 'database_tables_exist' => FALSE, 'forms' => array (), 'installation_finished' => FALSE, 'locales' => array (0 => class stdClass { public $name = 'en'; public $langcode = 'en' }, './profiles/standard/translations/drupal-7.0-rc2.ru.po' => class stdClass { public $uri = './profiles/standard/translations/drupal-7.0-rc2.ru.po'; public $filename = 'drupal-7.0-rc2.ru.po'; public $name = 'drupal-7.0-rc2.ru'; public $langcode = 'ru' }), 'parameters' => array ('profile' => 'standard', 'locale' => 'en'), 'parameters_changed' => FALSE, 'profile_info' => array ('name' => 'Standard', 'description' => 'Install with commonly used features pre-configured.', 'version' => '7.0', 'core' => '7.x', 'dependencies' => array (0 => 'user', 1 => 'filter', 2 => 'node', 3 => 'system', 4 => 'field_sql_storage', 5 => 'text', 6 => 'field', 7 => 'block', 8 => 'color', 9 => 'comment', 10 => 'contextual', 11 => 'dashboard', 12 => 'help', 13 => 'image', 14 => 'list', 15 => 'menu', 16 => 'number', 17 => 'options', 18 => 'path', 19 => 'taxonomy', 20 => 'dblog', 21 => 'search', 22 => 'shortcut', 23 => 'toolbar', 24 => 'overlay', 25 => 'field_ui', 26 => 'file', 27 => 'rdf'), 'files' => array (0 => 'standard.profile'), 'project' => 'drupal', 'datestamp' => '1294208756', 'distribution_name' => 'Drupal', 'hidden' => FALSE, 'php' => '5.2.4'), 'profiles' => array ('standard' => class stdClass { public $uri = './profiles/standard/standard.profile'; public $filename = 'standard.profile'; public $name = 'standard' }, 'minimal' => class stdClass { public $uri = './profiles/minimal/minimal.profile'; public $filename = 'minimal.profile'; public $name = 'minimal' }, 'testing' => class stdClass { public $uri = './profiles/testing/testing.profile'; public $filename = 'testing.profile'; public $name = 'testing' }), 'server' => array (), 'settings_verified' => FALSE, 'stop_page_request' => FALSE, 'task_not_complete' => FALSE, 'tasks_performed' => array (0 => 'install_select_profile', 1 => 'install_select_locale', 2 => 'install_load_profile'))) /local/www/example.com/includes/install.core.inc:80
[06-Jan-2011 08:02:50] PHP 4. install_run_task($task = array ('display_name' => 'Verify requirements', 'display' => TRUE, 'type' => 'normal', 'run' => 3, 'function' => 'install_verify_requirements'), $install_state = array ('interactive' => TRUE, 'active_task' => 'install_verify_requirements', 'completed_task' => NULL, 'database_tables_exist' => FALSE, 'forms' => array (), 'installation_finished' => FALSE, 'locales' => array (0 => class stdClass { public $name = 'en'; public $langcode = 'en' }, './profiles/standard/translations/drupal-7.0-rc2.ru.po' => class stdClass { public $uri = './profiles/standard/translations/drupal-7.0-rc2.ru.po'; public $filename = 'drupal-7.0-rc2.ru.po'; public $name = 'drupal-7.0-rc2.ru'; public $langcode = 'ru' }), 'parameters' => array ('profile' => 'standard', 'locale' => 'en'), 'parameters_changed' => FALSE, 'profile_info' => array ('name' => 'Standard', 'description' => 'Install with commonly used features pre-configured.', 'version' => '7.0', 'core' => '7.x', 'dependencies' => array (0 => 'user', 1 => 'filter', 2 => 'node', 3 => 'system', 4 => 'field_sql_storage', 5 => 'text', 6 => 'field', 7 => 'block', 8 => 'color', 9 => 'comment', 10 => 'contextual', 11 => 'dashboard', 12 => 'help', 13 => 'image', 14 => 'list', 15 => 'menu', 16 => 'number', 17 => 'options', 18 => 'path', 19 => 'taxonomy', 20 => 'dblog', 21 => 'search', 22 => 'shortcut', 23 => 'toolbar', 24 => 'overlay', 25 => 'field_ui', 26 => 'file', 27 => 'rdf'), 'files' => array (0 => 'standard.profile'), 'project' => 'drupal', 'datestamp' => '1294208756', 'distribution_name' => 'Drupal', 'hidden' => FALSE, 'php' => '5.2.4'), 'profiles' => array ('standard' => class stdClass { public $uri = './profiles/standard/standard.profile'; public $filename = 'standard.profile'; public $name = 'standard' }, 'minimal' => class stdClass { public $uri = './profiles/minimal/minimal.profile'; public $filename = 'minimal.profile'; public $name = 'minimal' }, 'testing' => class stdClass { public $uri = './profiles/testing/testing.profile'; public $filename = 'testing.profile'; public $name = 'testing' }), 'server' => array (), 'settings_verified' => FALSE, 'stop_page_request' => FALSE, 'task_not_complete' => FALSE, 'tasks_performed' => array (0 => 'install_select_profile', 1 => 'install_select_locale', 2 => 'install_load_profile'))) /local/www/example.com/includes/install.core.inc:343
[06-Jan-2011 08:02:50] PHP 5. install_verify_requirements($install_state = array ('interactive' => TRUE, 'active_task' => 'install_verify_requirements', 'completed_task' => NULL, 'database_tables_exist' => FALSE, 'forms' => array (), 'installation_finished' => FALSE, 'locales' => array (0 => class stdClass { public $name = 'en'; public $langcode = 'en' }, './profiles/standard/translations/drupal-7.0-rc2.ru.po' => class stdClass { public $uri = './profiles/standard/translations/drupal-7.0-rc2.ru.po'; public $filename = 'drupal-7.0-rc2.ru.po'; public $name = 'drupal-7.0-rc2.ru'; public $langcode = 'ru' }), 'parameters' => array ('profile' => 'standard', 'locale' => 'en'), 'parameters_changed' => FALSE, 'profile_info' => array ('name' => 'Standard', 'description' => 'Install with commonly used features pre-configured.', 'version' => '7.0', 'core' => '7.x', 'dependencies' => array (0 => 'user', 1 => 'filter', 2 => 'node', 3 => 'system', 4 => 'field_sql_storage', 5 => 'text', 6 => 'field', 7 => 'block', 8 => 'color', 9 => 'comment', 10 => 'contextual', 11 => 'dashboard', 12 => 'help', 13 => 'image', 14 => 'list', 15 => 'menu', 16 => 'number', 17 => 'options', 18 => 'path', 19 => 'taxonomy', 20 => 'dblog', 21 => 'search', 22 => 'shortcut', 23 => 'toolbar', 24 => 'overlay', 25 => 'field_ui', 26 => 'file', 27 => 'rdf'), 'files' => array (0 => 'standard.profile'), 'project' => 'drupal', 'datestamp' => '1294208756', 'distribution_name' => 'Drupal', 'hidden' => FALSE, 'php' => '5.2.4'), 'profiles' => array ('standard' => class stdClass { public $uri = './profiles/standard/standard.profile'; public $filename = 'standard.profile'; public $name = 'standard' }, 'minimal' => class stdClass { public $uri = './profiles/minimal/minimal.profile'; public $filename = 'minimal.profile'; public $name = 'minimal' }, 'testing' => class stdClass { public $uri = './profiles/testing/testing.profile'; public $filename = 'testing.profile'; public $name = 'testing' }), 'server' => array (), 'settings_verified' => FALSE, 'stop_page_request' => FALSE, 'task_not_complete' => FALSE, 'tasks_performed' => array (0 => 'install_select_profile', 1 => 'install_select_locale', 2 => 'install_load_profile'))) /local/www/example.com/includes/install.core.inc:474
[06-Jan-2011 08:02:50] PHP 6. install_check_requirements($install_state = array ('interactive' => TRUE, 'active_task' => 'install_verify_requirements', 'completed_task' => NULL, 'database_tables_exist' => FALSE, 'forms' => array (), 'installation_finished' => FALSE, 'locales' => array (0 => class stdClass { public $name = 'en'; public $langcode = 'en' }, './profiles/standard/translations/drupal-7.0-rc2.ru.po' => class stdClass { public $uri = './profiles/standard/translations/drupal-7.0-rc2.ru.po'; public $filename = 'drupal-7.0-rc2.ru.po'; public $name = 'drupal-7.0-rc2.ru'; public $langcode = 'ru' }), 'parameters' => array ('profile' => 'standard', 'locale' => 'en'), 'parameters_changed' => FALSE, 'profile_info' => array ('name' => 'Standard', 'description' => 'Install with commonly used features pre-configured.', 'version' => '7.0', 'core' => '7.x', 'dependencies' => array (0 => 'user', 1 => 'filter', 2 => 'node', 3 => 'system', 4 => 'field_sql_storage', 5 => 'text', 6 => 'field', 7 => 'block', 8 => 'color', 9 => 'comment', 10 => 'contextual', 11 => 'dashboard', 12 => 'help', 13 => 'image', 14 => 'list', 15 => 'menu', 16 => 'number', 17 => 'options', 18 => 'path', 19 => 'taxonomy', 20 => 'dblog', 21 => 'search', 22 => 'shortcut', 23 => 'toolbar', 24 => 'overlay', 25 => 'field_ui', 26 => 'file', 27 => 'rdf'), 'files' => array (0 => 'standard.profile'), 'project' => 'drupal', 'datestamp' => '1294208756', 'distribution_name' => 'Drupal', 'hidden' => FALSE, 'php' => '5.2.4'), 'profiles' => array ('standard' => class stdClass { public $uri = './profiles/standard/standard.profile'; public $filename = 'standard.profile'; public $name = 'standard' }, 'minimal' => class stdClass { public $uri = './profiles/minimal/minimal.profile'; public $filename = 'minimal.profile'; public $name = 'minimal' }, 'testing' => class stdClass { public $uri = './profiles/testing/testing.profile'; public $filename = 'testing.profile'; public $name = 'testing' }), 'server' => array (), 'settings_verified' => FALSE, 'stop_page_request' => FALSE, 'task_not_complete' => FALSE, 'tasks_performed' => array (0 => 'install_select_profile', 1 => 'install_select_locale', 2 => 'install_load_profile'))) /local/www/example.com/includes/install.core.inc:719
[06-Jan-2011 08:02:50] PHP 7. drupal_check_profile($profile = 'standard') /local/www/example.com/includes/install.core.inc:1551
[06-Jan-2011 08:02:50] PHP 8. module_load_install($module = 'filter') /local/www/example.com/includes/install.inc:1129
[06-Jan-2011 08:02:50] PHP 9. module_load_include($type = 'install', $module = 'filter', $name = *uninitialized*) /local/www/example.com/includes/module.inc:262
[06-Jan-2011 08:02:50] PHP 10. drupal_get_path($type = 'module', $name = 'filter') /local/www/example.com/includes/module.inc:298
[06-Jan-2011 08:02:50] PHP 11. drupal_get_filename($type = 'module', $name = 'filter', $filename = *uninitialized*) /local/www/example.com/includes/common.inc:2664
[06-Jan-2011 08:02:50] PHP 12. db_query($query = 'SELECT filename FROM {system} WHERE name = :name AND type = :type', $args = array (':name' => 'filter', ':type' => 'module'), $options = *uninitialized*) /local/www/example.com/includes/bootstrap.inc:679
[06-Jan-2011 08:02:50] PHP 13. Database::getConnection($target = 'default', $key = *uninitialized*) /local/www/example.com/includes/database/database.inc:2218
[06-Jan-2011 08:02:50] PHP 14. Database::openConnection($key = 'default', $target = 'default') /local/www/example.com/includes/database/database.inc:1363
[06-Jan-2011 08:02:50] PHP 15. DatabaseConnection_mysql->__construct($connection_options = array ('driver' => 'mysql', 'database' => 'drupal7', 'username' => 'drupal', 'password' => 'myDrupal', 'host' => 'localhost', 'prefix' => array ('default' => ''))) /local/www/example.com/includes/database/database.inc:1573

Comments

Same here

KirstenLangholz commented 14 January 2011 at 09:34

Hello,

I ran into the same poblem when I moved my D7 installation from XAMPP local installation to the 'Server2go' stick installation. I imported the database without any errors, but cannot open website afterwards. All rights set correctly.

Anybody with an idea where to turn to in order to solve the problem?

Thanks,
Kirsten

for me fix was installation

podarok

🇺🇦 he/him/his

Ukrainian

Ukraine

commented 27 January 2011 at 19:54

for me fix was installation php5-pdo_mysql (FreeBSD)
portinstall php5-pdo_mysql

---------------
Andrii Podanenko
CEO, ITCare

I have the same issue right

sinkarna commented 5 April 2012 at 17:01

I have the same issue right now but I don't understand what's the fix?

I suppose PDO_mysql module

Konstantin Boyandin commented 6 April 2012 at 03:32

I suppose PDO_mysql module was missing.

Uncommenting/Enable php_pdo_mysql.dll in php.ini

DrupalUser78 commented 11 June 2014 at 14:59

Exactly that was it for Server2go!

After enabling the line (=removing the leading ; semicolon)
extension=php_pdo_mysql.dll
in the file \server\config_tpl\php.ini this error was gone.

Don't forget to reboot/restart your (Server2go-) server.

Thank you for this hint!

it worked after enabling in php setting

balakumarjayapal commented 12 April 2015 at 06:02

it worked after enabling in php setting thanks

Thanks

cmak commented 7 February 2017 at 06:53

Thank you, enabling the php pdo extension solved the issue.

Senior Drupal Developer
Skype me on : mak_chavan
Email : Makarand Chavan

I had to install the

xamox commented 5 July 2012 at 16:01

I had to install the php5-mysql binding on Ubuntu linux with:
sudo apt-get install php5-mysql

On CentOS

chirale commented 23 October 2012 at 12:19

yum search php-mysql
yum install php-mysql.x86_64 (or similar)

Got same problem at nginx +

aliaric commented 21 September 2012 at 11:20

Got same problem at nginx + php-fpm
Seems I reinstalled php5-mysql extention and restarted php5-fpm.

Ubuntu's php5-mysql package

adityamenon commented 17 June 2015 at 05:40

Ubuntu's php5-mysql package probably installed the PDO driver for me. I just forgot to $ sudo service apache2 restart. It worked after that.

update your php.ini file

usman_ahmed commented 25 November 2015 at 07:50

if you are on liver server please create a php.ini file on root directory and add this in it
[PHP]
extension=pdo.so
extension=pdo_mysql.so
and save your file.
done

if you are on local host please open you php.ini file and add this code in it.

Fixed it for me

Kimberley_p commented 22 December 2015 at 20:25

Thanks very much after going round in circles a bit this simple fix worked for me.

Quick and smart solution.

monymirza

Urdu

Islamabad

commented 12 January 2016 at 05:19

Quick and smart solution. Excellent.

Acquia Certified Developer - Drupal

Keeping php.ini in C:\Windows fixed the problem

mvsagar commented 21 February 2016 at 12:43

Even though I had "extension=php_pdo_mysql.dll" in php.ini file and extension directory had the dll, the problem got fixed only after placing php.ini in C:\Windows directory.

Quick fix for wampmanager

Tommy_001 commented 16 April 2016 at 12:32

I had the same problem on a wamp environment and for me the solution was to simply go to Wamp->Apache->Version and click on the version number. Wait for 5 seconds or so until Apache is restarted. Done!

Quick fix for wampmanager - worked

stuarteske commented 25 October 2016 at 13:35

Thanks for that, worked for me.

I've hit this issue after

bovidiu commented 27 May 2016 at 17:31

I've hit this issue after installing memcache and trying to clear cache with drush.

To fix it, it wasn't need it to edit php.ini as much as it was missing php7.0-mysql . After installing it, i was able to run drush again (OS: Ubuntu 16)

Thanks bovidiu

shridhars commented 5 July 2016 at 05:10

after installing php7.0-mysql Undefined class constant 'MYSQL_ATTR_USE_BUFFERED_QUERY' issue resolved

thanks a lot, this solved my

michaljenicek commented 12 July 2016 at 21:04

thanks a lot, this solved my problem (I was upgrading from ubuntu 14.04 to 16.04)

Ran into this issue on Ubuntu 16.04

dorficus commented 24 January 2017 at 01:13

I checked my CLI php.ini and everything was enabled, however for some reason the CLI version of PHP was 7.1 but the mysql enabled was for 7.0. I ran sudo apt-get install php7.1-mysql and drush started working again.

php 7 pdo_mysql missing

arunkumark

Coimbatore

commented 15 February 2017 at 13:44

Hi,
Am also facing the same problem on upgrading PHP version for my website from PHP 5 to PHP 7. In default, the pdo_mysql module does not exist. We need to manually download and install to our server. After enabling pdo_mysql module it working properly.
Command for enable pdo_mysql in PHP 7

sudo apt-get install php7.0-mysql
sudo phpenmod pdo_mysql
sudo service apache2 restart

thanks @arunkumark

sudishth commented 13 July 2017 at 11:10

thanks @arunkumark

it working for me

Same error; working over SSH via command line on Linux

annier77 commented 25 May 2018 at 00:39

Hello there, I don't know if anyone still responds to these threads but I'm quite desperate.

I'm very much a newbie to Drupal and took over 'managing' our website around 6 months ago; all I ever do is update Drupal core when necessary. In January, I had a lot of trouble installing a new module because the PHP installation was incorrect, so I messed around a bit with it then, but still couldn't figure out the issue. However, the website was fine until a couple of weeks ago, when someone notified me that the webpage was now showing "Fatal error: Undefined class constant 'MYSQL_ATTR_USE_BUFFERED_QUERY' in .......[website name]....includes/database/mysql/database.inc on line 56".

Thereafter I came to this thread. As I mentioned before, I'm working over SSH via the command line on quite the unfamiliar system, so any help would be greatly appreciated.

I've already re-installed the newest Drupal version via Cyberduck by using "rm -rf *.txt *.php includes/ misc/ modules/ profiles/ scripts/ *.config" and then "cp -R ~/drupal-7.59/* ."

When I run "uname -a" I get "Linux box501.bluehost.com 3.10.0-693.11.6.1.ELK.el6.x86_64 #1 SMP Tue Jan 23 10:30:30 MST 2018 x86_64 x86_64 x86_64 GNU/Linux".

When I run "php -v" I get "

When I run "sudo" anything, I get "sudo: effective uid is not 0, is sudo installed setuid root?".

And when I run "yum -v" I get "CRITICAL:yum.cli:Config Error: Error accessing file for config file:///etc/yum.conf".

This last error worries me too as I was thinking I could maybe solve these PHP (?) issues using yum to install, as apt-get doesn't work. Since "sudo" doesn't work either, I'm quite at a loss, as I'm a novice with system administration. Again, any help would be great.

I have the same

AlbionBrown commented 1 June 2018 at 13:45

I have the same error using Drupal 7.59 and PHP 7.1. In the PHP status report, it says I have the pdo_mysql and php7.1-mysql packages installed.

"extension_dir" needs to be an absolute path on Windows

designcrs commented 29 July 2019 at 13:13

I had the same problem on Windows - running Drupal 8 on IIS. Checking the output of phpinfo() made clear that the PDO module was not loaded. The fix was to change the "extension_dir" setting in php.ini to an absolute path. In my case this was

extension_dir = "C:\php\ext"