• Can’t login to the CMS, and the blog is dead. Please help asap. Database problems after upgrade to WordPress 3.6.1, as reported by WordPress:

    wp_users: Table upgrade required. Please do “REPAIR TABLE wp_us” or dump/reload to fix it!
    wp_links: Table upgrade required. Please do “REPAIR TABLE wpwp_users: Table upgrade required. Please do "REPAIR TABLEwp_users`” or dump/reload to fix it!
    wp_links: Table upgrade required. Please do “REPAIR TABLE wp_links” or dump/reload to fix it!
    wp_terms: Table upgrade required. Please do “REPAIR TABLE wp_terms” or dump/reload to fix it!
    wp_term_taxonomy: Table upgrade required. Please do “REPAIR TABLE wp_term_taxonomy” or dump/reload to fix it!
    wp_commentmeta: Table upgrade required. Please do “REPAIR TABLE wp_commentmeta” or dump/reload to fix it!_links`” or dump/reload to fix it!
    wp_terms: Table upgrade required. Please do “REPAIR TABLE wp_terms” or dump/reload to fix it!
    wp_term_taxonomy: Table upgrade required. Please do “REPAIR TABLE wp_term_taxonomy” or dump/reload to fix it!
    wp_commentmeta: Table upgrade required. Please do “REPAIR TABLE wp_commentmeta” or dump/reload to fix it!

Viewing 4 replies - 1 through 4 (of 4 total)
  • This could be caused by a MySQL binary upgrade on the server (without a dump and reload of the tables) or corrupted tables.

    Maybe someone who’s had this problem before can chime in, but basically the messages are telling you what you need to do. Run:

    REPAIR TABLE wp_terms

    at a MySQL command line or via phpMyAdmin (or equivalent), obviously for every table listed. Be sure and do a database backup first.

    Thread Starter ChWebP

    (@chewebpro)

    Thanks! Most were successful. Two failed because the tables do not exist!?

    As an alternative attempt to fix this, I imported the backup sql file from before this issue happened, and the import was successful, but I still cannot login to the WP CMS. “Error establishing a database connection”

    Check your wp-config.php file and make sure everything with regards to the database is correct. (database name, host, username, password) If any of those items are wrong, then you will get the message:

    Error establishing a database connection

    You would also get that error if MySQL itself wasn’t running.

    Thread Starter ChWebP

    (@chewebpro)

    I noticed that the server name in the config.php no longer matched that in mySql – one character was different. I updated config.php to match and now the blog is back! But how can that change on its own?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Blog Died After Upgrade!’ is closed to new replies.