pdo_mysql error suddenly appears on drupal based website?

ammar26 picture ammar26 · Sep 23, 2011 · Viewed 11.9k times · Source

My drupal based website was working fine till yesterday but suddenly from no where today an error appeared

Fatal error: Undefined class constant 'MYSQL_ATTR_USE_BUFFERED_QUERY' in /.../includes/database/mysql/database.inc on line 43

I didn't even changed or updated anything since yesterday, it suddenly appears from no where, before that it was working fine

On line 43 of database.inc this was written

 PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => TRUE,

I googled and got some idea that this is some sort of PDO_MYSQL error, i have not much idea why this error suddenly arrived

Can anyone please help me out

Additional information

  • Linux Shared Webhosting
  • DRUPAL 7
  • Apache version 2.2.20
  • PHP version 5.2.17
  • MySQL version 5.0.92-community-log
  • cPanel Version 11.30.3 (build 5)

Answer

Clive picture Clive · Sep 23, 2011

According to a lot of different sources the pdo_mysql extension must be missing from your PHP installation. Either add it in php.ini or ask your hosting provider to do it for you.

Links:

They all say the same thing...install the pdo_mysql extension. Sounds like your hosting provider has disabled it!