开发者

pdo_mysql error suddenly appears on drupal based website?

开发者 https://www.devze.com 2023-04-06 18:46 出处:网络
My drupal based website was working fine till yesterday but suddenly from no where today an error appeared

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开发者_如何学C.17
  • MySQL version 5.0.92-community-log
  • cPanel Version 11.30.3 (build 5)


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:

  • Fatal error in D7 HEAD while running 'drush update'
  • Drupal 7: PHP fatal error 'Undefined class constant MYSQL_ATTR_USE_BUFFERED_QUERY' when trying to install on MySQL database
  • Fatal Error: Undefined class constant 'MYSQL_ATTR_USE_BUFFERED_QUERY'

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


This can also be due to a permissions issue. Sometimes, given the use of SuPHP or other configurations in which the apache (or other server) user can't run a file, you'll get this sort of error and PDO_MYSQL: will already be installed and operational.

If you have root access to the box, try doing a

sudo php /path/to/your/php/script.php

or recursively chown the directory to the appropriate apache user (usually apache or www-data) or the user who's home directory your files are resting in (the case in most shared servers).

chown -R apache:apache /path/to/web/files


I had exactly the same problem. My site suddenly went down. I started looking at installing php extension php_pdo_mysql.dll from cPanel PHP PEAR as suggested above, but this failed. I started a live chat with my host (Justhost) and it tuned out they had upgraded their php version. They fixed it in 2 minues.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号