If you are on a dedicated host, many allow you the option of choosing which version of PHP to run. If you are using MAMP or WAMP, it is easy using the tidbit below. We downgraded below PHP version 5.5 so that WordPress would use mysql instead of mysqli. The Windows counterpart to this is WAMP which stands for Windows, Apache, MySQL and PHP.įor our scenario of needing to run a backup, we simply downgraded the version of PHP that we were running. MAMP is an Open Source local development tool that allows you to run MacOS, Apache, MySQL and PHP. Thankfully in MAMP and also WAMP environments, it is easy to switch between versions of PHP and get around this error. The deprecation notices are harmless in this scenario – but they can easily junk up logs and such. When using the mysql extension on versions of PHP 5.x you would see deprecation notices.
Or – put another way – if your PHP installation was running PHP 5.5 or higher, you would get mysqli by default, if lower then 5.5 you would use mysql. At that point it was gated by PHP 5.5 or higher. WordPress added support for the mysqli extension about 6 years ago (maybe 2013 timeframe give or take). Web developers need to rely on the mysqli (MySQL Improved) extension or PDO (PHP Data Objects) in its place.
In PHP 7.x, the extension itself was removed. Starting in PHP 5.x the mysql extension, mysql_connect and associated calls were all marked for deprecation. This will update the database code files and provide a solution. To fix this issue in a production style WordPress installation, update the core WordPress files to the current version. To fix this specific issue, we would need to setup and installation using an older version of PHP, in order to run our older backup of WordPress. Our issue is that WordPress in this case is out of date.
The issue here is that we were running a version of WordPress, that requires the MySQL extension, which was removed in PHP. When we went to run the site, we got the following error: “Your PHP installation appears to be missing the MySQL extension which is required by WordPress.” We had a local installation of MAMP setup to do the work. A couple days ago I was helping someone revise an old archive/backup of a WordPress installation.
0 kommentar(er)
