Hello friends,
Hope you can help me out here.
I need to migrate a website running a legacy theme that cannot be updated in the current webhost, that’s why I need to migrate it to my server with Hestia v1.9.2.
I cannot make it to connect Wordpress (old v4.7) to database when running php 5.6
It’s NOT the credentials, they work fine if I install on php 7.0 onwards, but if I use those recent versions of php the website theme and plugins break and the site is not usable.
So, what I need is to migrate the site as it is right now and make it a stage site where I can work on updating all components safely, and not doing it on the live site. Once I have everything running fine then I can change the domain records (and site url settings, and all references in Wordpress database) to point to this or any other needed webhost provider.
Errors:
When trying php 7.0 onwards I get http 500 error
[Tue Feb 11 19:54:20.444454 2025] [proxy_fcgi:error] [pid 9803:tid 9810] [client 201.205.242.170:0] AH01071: Got error ‘PHP message: PHP Fatal error: __autoload() is no longer supported, use spl_autoload_register() instead in /home/renatocoto/web/site/public_html/wp-includes/compat.php on line 502’
When using php 5.6 I get Error establishing a database connection
[Tue Feb 11 19:55:37.113209 2025] [proxy_fcgi:error] [pid 11271:tid 11296] [client 201.205.242.170:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught Error: Call to undefined function mysql_error() in /home/renatocoto/web/site/public_html/wp-content/plugins/revslider/inc_php/framework/db.class.php:29\nStack trace:\n#0 /home/renatocoto/web/site/public_html/wp-content/plugins/revslider/inc_php/framework/db.class.php(124): UniteDBRev->checkForErrors()\n#1 /home/renatocoto/web/site/public_html/wp-content/plugins/revslider/inc_php/revslider_slider.class.php(1431): UniteDBRev->fetch()\n#2 /home/renatocoto/web/site/public_html/wp-content/plugins/revslider/inc_php/revslider_slider.class.php(1474): RevSlider->getArrSliders()\n#3 /home/renatocoto/web/site/public_html/wp-content/themes/jupiter/page-composer/config/map.php(87): RevSlider->getArrSlidersShort()\n#4 /home/renatocoto/web/site/public_html/wp-content/themes/jupiter/page-composer/js_composer.php(93): require_once(’/home/renatocot…‘)\n#5 /home/renatocoto/web/site…’
Test:
As a test, I tried running the installation of a new Wordpress (same old v4.7) and when using php 5.6 the installer complains it cannot connect to the MySQL database, but if I change in Hestia that site to use php 7.0 or newer, the installation runs fine, using the same credentials, so it’s not a credentials typo.
Troubleshooting:
I’ve changed the database user authentication method from caching_sha2_password to mysql_native_password but didn´t resolve the issue.
Please your help and guidance is appreciated.
Renato