warning: mysql_query(): unable to save result set in wordpress
Tweet Follow @3pixelssolutionWarning: mysqli_query(): MySQL server has gone away in siteroot\wp-includes\wp-db.php on line 1878
and
Warning: mysqli_query(): Error reading result set's header in siteroot\wp-includes\wp-db.php on line 1878
Modify your wp-config.php file
Open wp-config.php with a text editor such as Notepad. The wp-config.php file is located in your WordPress installation folder in your hosting account. If there is no file called wp-config.php, open wp-config-sample.php and save it as wp-config.php. You will be working in this file from now on.
In wp-config.php, locate the section that looks like this example:
define(‘DB_NAME’, ‘putyourdbnamehere’);
/** MySQL database username */
define(‘DB_USER’, ‘usernamehere’);
/** MySQL database password */
define(‘DB_PASSWORD’, ‘yourpasswordhere’);
/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);
Enter the Database information from your Database as follows:
- putyourdbnamehere is your MySQL Database Name
- usernamehere is your MySQL User Name
- yourpasswordhere is your MySQL password
- localhost is your MySQL Host Name
WordPress includes security keys which add encryption of information stored in user’s cookies. These must be set manually in the wp-config.php file. Locate the section of the file that looks like this:
define(‘SECURE_AUTH_KEY’, ‘put your unique phrase here’);
define(‘LOGGED_IN_KEY’, ‘put your unique phrase here’);
define(‘NONCE_KEY’, ‘put your unique phrase here’);
Go to WordPress’ online key generator and insert the keys in place of the placeholder text in the wp-config.php file. When you are finished, save and close the wp-config.php file.