• Everything was find and dandy until I upgraded it 2.01. Now I am getting this error:

    WordPress database error: [Lost connection to MySQL server during query]
    SELECT
    comment_post_ID as post_id, COUNT(comment_ID) as comment_count, comment_approved FROM wp_comments GROUP BY comment_post_ID

    Does anybody know what this means?

Viewing 6 replies - 1 through 6 (of 6 total)
  • At the upgrade, did you follow the upgrade instructions?

    o Backed up
    o Deleted all files except wp-config.php, .htaccess and the wp-content directory
    o Uploaded the new distribution exept the wp-content directory
    o Run the upgrade.php script from your browser.

    An upgrade may lead to some changes in the database.

    Thread Starter soyola

    (@soyola)

    I did everything

    I have the same issue with WP 2.01 when posting.
    This is the error message:
    WordPress database error: [Lost connection to MySQL server during query]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’59’,’_pingme’,’1′)

    Warning: Cannot modify header information – headers already sent by (output started at /ainostriamici/wp-includes/wp-db.php:102) in /ainostriamici/wp-admin/post.php on line 59

    Anyway the post will be published, but even if I have disabled comments, they will appear the same.
    I have again to edit the post a 2°time in order to effectively disable comments in the post.

    Hello all,
    I have exactly the same message on two differents blogs :

    WordPress database error: [Lost connection to MySQL server during query]
    SELECT option_value FROM vhd_wp_options WHERE option_name = ‘sm_options’ LIMIT 1

    This is 2.01. As soon as I publish a new note, it takes a long time then I get the error message.The post is ok when I come back to the frontpage.

    I foolowed the exact upgrade procedure for the both sites.

    I found a plugin that helps with the problem of database connection errors when posting. It is the No Ping Wait plugin and since I have been using it I have not had any connection errors. You can get it here:

    http://somethingunpredictable.com/wp-no-ping-wait/

    Just put it in your plugins folder and activate then your all set.

    This is the solution I found for this problem.

    Sign in to your wp-admin. Go to Options > Writing > Update Services. Delete ALL update services except:

    http://rpc.pingomatic.com/

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘database error – [Lost connection to MySQL server during query]’ is closed to new replies.