In fact, we don’t support versions below PHP 8.0. Note – at Kinsta, we strongly recommend using the latest version of PHP. On the other hand, if you’re still using PHP 5.X, you might be missing the MySQL extension. If your PHP version starts with a “7”, that usually means that you need to update the WordPress software. 7.2.25 or 5.6.8: How to check your WordPress site’s PHP version Pay attention to the numbers – you should see something like x.x.x. Scroll down to the Core section and look for the PHP Version item. You should see a screen that displays a lot of different information about the PHP configuration on your server. Once you save the file (and re-upload the saved version if needed), navigate to /phpinfo.php, making sure to replace with your actual domain name. Then, edit the file and add the following code snippet: This should be the same folder that contains your wp-config.php file. Once you’ve connected to your server, create a new file called phpinfo.php in the root directory of your WordPress site. If your host is using cPanel, you can use the cPanel File Manager tool. You can get your FTP credentials from your web host and you’ll also need an FTP client to connect. To check this, connect to your WordPress site’s server using FTP. The answer to this question will dictate the next steps that you take. The first step to diagnose this issue is to figure out which version of PHP your WordPress site’s server is running. Now that you know what’s going on, let’s go over some tips for how to troubleshoot and fix the issue.ġ. □ Click below for the full walkthrough! Click to Tweet How to Fix “Your PHP installation appears to be missing the MySQL extension which is required by WordPress” If you've ever seen this □ error then you know how frustrating it is to be unable to access your site. The other likely cause is that you are using PHP 5.6 (before the MySQL extension was deprecated), but the extension is either missing or improperly configured. You’re Using PHP 5.6 or Lower but the Extension Is Missing or Improperly Configured However, older versions of WordPress (below version 3.9) might cause this problem. Modern versions of WordPress will instead use the newer PDO_MySQL or MySQLi extensions. That is, PHP 7+ no longer includes the MySQL extension that WordPress is looking for. If you’re using a very old version of WordPress with a modern version of PHP, you might encounter this error because PHP 7.0 deprecated the MySQL extension in favor of MySQLi. You’re Using an Outdated Version of WordPress with PHP 7+ There are two main reasons why this might be the case: 1. # grep "servers" /usr/share/mysql/mysql_system_tables.sql | MYSQL_PWD=`cat /etc/psa/.psa.Get fast and secure WordPress hosting, complete with CDN, edge caching, 35 data centers, and enterprise-level features included in all plans. Restore the table by executing the following query: # grep "servers" /usr/share/mysql/mysql_system_tables.sqlĬREATE TABLE IF NOT EXISTS servers ( Server_name char(64) NOT NULL DEFAULT '', Host char(64) NOT NULL DEFAULT '', Db char(64) NOT NULL DEFAULT '', Username char(64) NOT NULL DEFAULT '', Password char(64) NOT NULL DEFAULT '', Port INT(4) NOT NULL DEFAULT '0', Socket char(64) NOT NULL DEFAULT '', Wrapper char(64) NOT NULL DEFAULT '', Owner char(64) NOT NULL DEFAULT '', PRIMARY KEY (Server_name)) CHARACTER SET utf8 comment='MySQL Foreign Servers table' # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_fix_privilege_tables -user=admin -verbose Update all the mysql privilege tables to be usable by the current version of MySQL # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin mysqlįor the versions of MySQL Server below 5.1, use the following method: Please contact your hosting provider support or server's administrator if you don't have SSH access or ask them to apply the solution.Ĭonnect to the server via SSH and run the following command for repairing MySQL table: Note: To apply the solution from this article it is required to have SSH access to the server. WHERE d.type = 'mysql' AND a.type = 'plain' INNER JOIN psa.data_bases d ON (u.db_id = d.id) INNER JOIN psa.accounts a ON (u.account_id = a.id) INNER JOIN psa.db_users u ON (m.User = u.login) Plesk or its components installation / upgrade failed with the error in the /var/log/plesk/install/autoinstaller3.log:ĬONFIG_TEXT: ERROR 1146 (42S02) at line 1: Table 'rvers' doesn't existĮRROR while trying to (to Convert MySQL DB users passwords to new format), the query was: UPDATE er m
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |