Title: Database Problem
Last modified: August 19, 2016

---

# Database Problem

 *  [RobertBruce](https://wordpress.org/support/users/robertbruce/)
 * (@robertbruce)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/database-problem-11/)
 * Below are samples of the errors messages that pop up all too frequently. As I
   am not at all a coder or programmer, I cannot decypher what the errors are so
   do not understand what is happening.
 * These error messages have only started happening since upgrading to 2.7
 * Please advise what is happening and how to correct the problem:
 * **ERROR MESSAGE IN DASHBOARD:**
 * _**THIS HAPPENS WHEN I SAVE A DRAFT:**_
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘IWG_RoleMan_Spaces_in_Caps’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘stats_url’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    CREATE TABLE IF NOT EXISTS
   _xxxxxxdl ( id INTEGER UNSIGNED NOT NULL auto_increment, description VARCHAR(
   255) NOT NULL default ”, category VARCHAR(64) NOT NULL default ”, url VARCHAR(
   255) NOT NULL default ”, owner INTEGER NOT NULL default 1, page INTEGER NOT NULL
   default 0, position INTEGER NOT NULL default 0, date DATETIME NOT NULL default‘
   0000-00-00 00:00:00’, creation_date DATETIME NOT NULL default ‘0000-00-00 00:
   00:00’, protected INTEGER UNSIGNED NOT NULL default 0, PRIMARY KEY(id))
 * WordPress database error: [MySQL server has gone away]
    CREATE TABLE IF NOT EXISTS
   _xxxxxxdlmap ( id INTEGER UNSIGNED NOT NULL auto_increment, url VARCHAR(255) 
   NOT NULL default ”, localpath VARCHAR(255) NOT NULL default ”, PRIMARY KEY(id))
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxdlmap
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘rich_editing’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘google_server_type’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘google_cur’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * Warning: Cannot modify header information – headers already sent by (output started
   at /data/16/1/38/37/1527526/user/1644137/htdocs/wordpress/wp-includes/wp-db.php:
   517) in /data/16/1/38/37/1527526/user/1644137/htdocs/wordpress/wp-includes/pluggable.
   php on line 850
 * _**WHEN LOGGING IN THIS ERROR POPS UP:**_
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘IWG_RoleMan_Spaces_in_Caps’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘stats_url’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    CREATE TABLE IF NOT EXISTS
   _xxxxxxdl ( id INTEGER UNSIGNED NOT NULL auto_increment, description VARCHAR(
   255) NOT NULL default ”, category VARCHAR(64) NOT NULL default ”, url VARCHAR(
   255) NOT NULL default ”, owner INTEGER NOT NULL default 1, page INTEGER NOT NULL
   default 0, position INTEGER NOT NULL default 0, date DATETIME NOT NULL default‘
   0000-00-00 00:00:00’, creation_date DATETIME NOT NULL default ‘0000-00-00 00:
   00:00’, protected INTEGER UNSIGNED NOT NULL default 0, PRIMARY KEY(id))
 * WordPress database error: [MySQL server has gone away]
    CREATE TABLE IF NOT EXISTS
   _xxxxxxdlmap ( id INTEGER UNSIGNED NOT NULL auto_increment, url VARCHAR(255) 
   NOT NULL default ”, localpath VARCHAR(255) NOT NULL default ”, PRIMARY KEY(id))
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxdlmap
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘rich_editing’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘google_server_type’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘google_cur’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * Warning: Cannot modify header information – headers already sent by (output started
   at /data/16/1/38/37/1527526/user/1644137/htdocs/wordpress/wp-includes/wp-db.php:
   517) in /data/16/1/38/37/1527526/user/1644137/htdocs/wordpress/wp-includes/pluggable.
   php on line 850
 * Warning: Cannot modify header information – headers already sent by (output started
   at /data/16/1/38/37/1527526/user/1644137/htdocs/wordpress/wp-includes/wp-db.php:
   517) in /data/16/1/38/37/1527526/user/1644137/htdocs/wordpress/wp-includes/pluggable.
   php on line 850
 * WordPress database error: [MySQL server has gone away]
    UPDATE _xxxxxxoptions
   SET option_value = ‘1232124150’ WHERE option_name = ‘aktt_doing_tweet_download’
 * WordPress database error: [MySQL server has gone away]
    UPDATE _xxxxxxoptions
   SET option_value = ‘0’ WHERE option_name = ‘aktt_doing_tweet_download’
 * _**DASHBOARD RETURNED THE FOLLOWING WHEN I CLICKED ‘WRITE TWEET’**_
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘IWG_RoleMan_Spaces_in_Caps’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘stats_url’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    CREATE TABLE IF NOT EXISTS
   _xxxxxxdl ( id INTEGER UNSIGNED NOT NULL auto_increment, description VARCHAR(
   255) NOT NULL default ”, category VARCHAR(64) NOT NULL default ”, url VARCHAR(
   255) NOT NULL default ”, owner INTEGER NOT NULL default 1, page INTEGER NOT NULL
   default 0, position INTEGER NOT NULL default 0, date DATETIME NOT NULL default‘
   0000-00-00 00:00:00’, creation_date DATETIME NOT NULL default ‘0000-00-00 00:
   00:00’, protected INTEGER UNSIGNED NOT NULL default 0, PRIMARY KEY(id))
 * WordPress database error: [MySQL server has gone away]
    CREATE TABLE IF NOT EXISTS
   _xxxxxxdlmap ( id INTEGER UNSIGNED NOT NULL auto_increment, url VARCHAR(255) 
   NOT NULL default ”, localpath VARCHAR(255) NOT NULL default ”, PRIMARY KEY(id))
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxdlmap
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘rich_editing’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘google_server_type’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM
   _xxxxxxoptions WHERE option_name = ‘google_cur’ LIMIT 1
 * WordPress database error: [MySQL server has gone away]
    SELECT * FROM _xxxxxxusers
   WHERE user_login = ‘admin’
 * Warning: Cannot modify header information – headers already sent by (output started
   at /data/16/1/38/37/1527526/user/1644137/htdocs/wordpress/wp-includes/wp-db.php:
   517) in /data/16/1/38/37/1527526/user/1644137/htdocs/wordpress/wp-includes/pluggable.
   php on line 850

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/database-problem-11/#post-963152)
 * I would turn off all plugins and activate them one by one to see which is the
   offender.
 *  [alwyn-botha](https://wordpress.org/support/users/alwyn-botha/)
 * (@alwyn-botha)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/database-problem-11/#post-963212)
 * [http://dev.mysql.com/doc/refman/5.0/en/gone-away.html](http://dev.mysql.com/doc/refman/5.0/en/gone-away.html)
 * The most common reason for the MySQL server has gone away error is that the server
   timed out and closed the connection. In this case, you normally get one of the
   following error codes (which one you get is operating system-dependent.
 * easy to fix: timeout values.
 *  [alwyn-botha](https://wordpress.org/support/users/alwyn-botha/)
 * (@alwyn-botha)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/database-problem-11/#post-963213)
 * [http://codex.wordpress.org/FAQ_Troubleshooting#How_do_I_solve_the_Headers_already_sent_warning_problem.3F](http://codex.wordpress.org/FAQ_Troubleshooting#How_do_I_solve_the_Headers_already_sent_warning_problem.3F)
 *  Thread Starter [RobertBruce](https://wordpress.org/support/users/robertbruce/)
 * (@robertbruce)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/database-problem-11/#post-963342)
 * Alwyn,
 * Dankie meneer! I’ll check the config en config_function files as they are the
   last files I edited.
 * I did not think to check them.
 * Mooi bly.
 * RB

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Database Problem’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [WP2.7](https://wordpress.org/support/topic-tag/wp2-7/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [RobertBruce](https://wordpress.org/support/users/robertbruce/)
 * Last activity: [17 years, 4 months ago](https://wordpress.org/support/topic/database-problem-11/#post-963342)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics