Database Problem
-
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 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘stats_url’ LIMIT 1WordPress 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 _xxxxxxdlmapWordPress 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 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘google_server_type’ LIMIT 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘google_cur’ LIMIT 1WordPress 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 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘stats_url’ LIMIT 1WordPress 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 _xxxxxxdlmapWordPress 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 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘google_server_type’ LIMIT 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘google_cur’ LIMIT 1WordPress 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 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘stats_url’ LIMIT 1WordPress 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 _xxxxxxdlmapWordPress 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 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘google_server_type’ LIMIT 1WordPress database error: [MySQL server has gone away]
SELECT option_value FROM _xxxxxxoptions WHERE option_name = ‘google_cur’ LIMIT 1WordPress 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
- The topic ‘Database Problem’ is closed to new replies.