Support » Fixing WordPress » Sql errors

  • not sure when or why but noticed this sql error, any ideas?

    i can still post and everything seems ok, but takes awhile to post, and when it does this is what i get. the lost connection thing is the problem?

    WordPress database error: [Lost connection to MySQL server during query]
    SHOW TABLES LIKE ‘wp_tla_data’

    WordPress database error: [MySQL server has gone away]
    SHOW TABLES;

    WordPress database error: [MySQL server has gone away]
    CREATE TABLE wp_tla_data ( id int(10) UNSIGNED NOT NULL AUTO_INCREMENT, url TEXT NOT NULL, text TEXT NOT NULL, before_text TEXT NOT NULL, after_text TEXT NOT NULL, rss_text TEXT NOT NULL, rss_before_text TEXT NOT NULL, rss_after_text TEXT NOT NULL, rss_prefix VARCHAR(255) NOT NULL DEFAULT ”, PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=1

    WordPress database error: [MySQL server has gone away]
    SHOW TABLES;

    WordPress database error: [MySQL server has gone away]
    CREATE TABLE wp_tla_rss_map ( post_id INT( 10 ) UNSIGNED NOT NULL DEFAULT ‘0’, advertisement TEXT NOT NULL , PRIMARY KEY ( post_id ) ) TYPE = MYISAM

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_tla_data

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_tla_rss_map ORDER BY post_id DESC LIMIT 10

    WordPress database error: [MySQL server has gone away]
    INSERT IGNORE INTO wp_tla_rss_map SET post_id = ’87’, advertisement = ”

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’87’,’_pingme’,’1′)

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’87’,’_encloseme’,’1′)

    WordPress database error: [MySQL server has gone away]
    SELECT ID FROM wp_posts WHERE TRIM(to_ping) != ” LIMIT 1

    WordPress database error: [MySQL server has gone away]
    SELECT post_id FROM wp_postmeta WHERE meta_key = ‘_pingme’ OR meta_key = ‘_encloseme’ LIMIT 1

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_posts SET post_parent = 87 WHERE post_parent = -1175174741

Viewing 5 replies - 1 through 5 (of 5 total)
  • You definitely want to share some of that with your host.

    godaddy strikes again huh

    I’ve probbably made over a 100 trouble free installs with godaddy and never seen that. Definitely call or email them. Their support has become quite excellent.

    actually, the site has been running for months, everything functions fine, a little slow but fine otherwise…the timeout and connection must be the problem on their side

    trblclef,

    Here we had that trouble. Find the file that creates the database and change TYPE=MyISAM for TYPE=ENGINE, ok?
    At least, when we did it once and that worked.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Sql errors’ is closed to new replies.