Support » Fixing WordPress » Categories all disappeared

  • Resolved jasoncann

    (@jasoncann)


    Hi all,

    A very unusual situation occurred this morning once I logged in. All my posts had been recategorized to Uncategorized. Going to /wp-admin/categories.php all my categories appeared to have been removed. So I go to recreate them and get “The category you are trying to create already exists.”

    Now the categories do not appear here: /wp-admin/categories.php nor do the categories appear when I edit the post and select “All Categories” from the category box. However, if I select “Most Used” from the category box some of the categories appear, but if I attempt to use one of them in the most used list and save it. It does not seem to reflect on the site.

    Can someone please provide me some direction on how to correct this.

Viewing 6 replies - 1 through 6 (of 6 total)
  • MichaelH

    (@michaelh)

    Please review this thread (even though the problem never got solved) for possible options:

    http://wordpress.org/support/topic/252107

    Thread Starter jasoncann

    (@jasoncann)

    Thank you.

    The solution was to restart MySQL. All content returned.

    MichaelH

    (@michaelh)

    I like those kind of solutions. Thanks for the report.

    chrispeary

    (@chrispeary)

    All my categories have just disappeared too. I had my host restart MySQL, but to no avail. I’ve also checked/repaired my database, updated my plugins, reset my permalinks, and everything else I can find in these forums, but still no luck.

    Has anyone made any progress on this problem?

    chrispeary

    (@chrispeary)

    OK, my categories are back. 🙂 I’m not exactly sure which step worked, but something went right during the following steps:

    1. Updated all my plugins
    2. Requested my host restart MySQL
    3. Ran this SQL script in myPHPadmin:
      UPDATE wp_term_taxonomy,wp_terms SET wp_term_taxonomy.description = wp_terms.name WHERE wp_term_taxonomy.term_id = wp_terms.term_id
    4. Checked/repaired database
    5. Backed up my database (in case I had to restore an older version and things didn’t work out)

    My categories still weren’t back when I looked, but I hesitated to restore an older database backup. Then, about an hour later, my categories reappeared. I don’t know which step did it, but it definitely wasn’t my permalinks. xP

    Hope this helps!

    Running the SQL Query:
    UPDATE wp_term_taxonomy,wp_terms SET wp_term_taxonomy.description = wp_terms.name WHERE wp_term_taxonomy.term_id = wp_terms.term_id

    Fixed it 🙂

    WordPress 2.9.1

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Categories all disappeared’ is closed to new replies.