WordPress.org

Ready to get started?Download WordPress

Forums

Database Problem (5 posts)

  1. RobertBruce
    Member
    Posted 5 years ago #

    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

  2. Samuel B
    moderator
    Posted 5 years ago #

    I would turn off all plugins and activate them one by one to see which is the offender.

  3. Alwyn Botha
    Member
    Posted 5 years ago #

    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.

  4. Alwyn Botha
    Member
    Posted 5 years ago #

  5. RobertBruce
    Member
    Posted 5 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic