After upgrading to PHP 7 or higher you may encounter the following error:
SQL ERROR [ mysql4 ]
mysql_connect function does not exist, is mysql extension installed? 
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
The reason for this is the mysql request is deprecated in the new version of PHP, as part of the security update to 7 from 5.6.40. All that needs to be done is to modify the configuration file and switch the configuration file from “mysql” to “mysqli” as the method for requesting the database.
As many are aware, the hosting industry has been upgrading PHP to its latest version of 7.3.3 for additional security. Many of the original themes that have not been updated contain code that is only compatible with PHP 5.6.40.
This fix applies to RocketTheme WordPress Templates but may also apply to others as well. Part of the Rockettheme core contains RokCommon components. If you have recently upgraded from PHP 5.6.40 to PHP 7.* you may experience a blank page for WordPress after the upgrade.
The fix is to
- Download the latest RokCommon Core here: https://rockettheme.com/wordpress/plugins/rokutilities
- Once the zip file has been downloaded, unzip the file and locate the “wp_RokCommon” folder.
- Upload all of these files to your WordPress plugin directory located in: (Your WordPress Install Directory)\wp-content\plugins\wp_rokcommon\
- Overwrite the existing files. This will fix the incompatibility issue, when you refresh the site it should now be live and functioning on PHP 7.3.3.
To all of the Irish out there… Happy St. Patrick’s Day 🙂
Symptoms: The following errors are found in the web server error logs:
Connection reset by peer: mod_fcgid: error reading data from FastCGI server
Premature end of script headers: index.php
Solutions: This is one of those frustrating errors that can take a long time to fix and may be dependent on multiple problems. The solution that worked in my case was adding:
ini_set(‘zend.enable_gc’, 0); <<Below the <?php tag in the index.php
Why does this work? There are known conflicts between zend and APC, if both are installed you may receive the above error, adding the above code into your php file should resolve your issue.
Other possible solutions: Modify your php.ini to increase max_execution_time, post_max_size, and max_input_time :: IMPORTANT – Make sure you maintain a limit, no limit could result in massive resource usage.