Support » Fixing WordPress » Categories, links and tags disappeared

  • Resolved kwdavids


    Sometime today all the articles on my blog reverted to Uncategorized, all the Tags went away, and the Blog Roll became empty. Whether this is related to a post-failure restore by my hosting service last night or not, I can’t be sure (my guess is not). The problem affects 4 different blogs.

    In the Admin interface, Categories says “96” entries, but the list has “no items found.”

    If I list Links in the admin interface, the links are there with the correct Link Category names, but if I list the Link categories, it says “6 entries” but the list has “no items found.”

    When I look at Tags in the Admin interface, they are all there with counts; however, if I click to view any of them, noting is displayed.

    I’ve poked in the WordPress database tables and they look right so far as I can tell. I can see the actual items in WP_TERMS and the ID’s match up to the WP_LINKS table

    This makes me speculate that queries are broken and that my hosting company may have changed something.

    I’m in a mess.

    MySQL version 5.1.56
    Perl version 5.8.8
    PHP version 5.2.17

Viewing 5 replies - 1 through 5 (of 5 total)
  • The hosting company swears that they didn’t change anything in MySQL, but it got fixed. I looked in the error log and saw tons of errors, for example:

    WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘link_category’) AND tt.count > 0 ORDER BY ASC made by require, require_once, include, get_footer, locate_template, load_template, require_once, woo_footer_top, woo_do_atomic, do_action, call_user_func_array, woo_footer_sidebars, woo_sidebar, dynamic_sidebar, call_user_func_array, WidgetCache->widget_cache_redirected_callback, call_user_func_array, WP_Widget->display_callback, WP_Widget_Links->widget, wp_list_bookmarks, get_terms

    and I also saw a bunch of these:

    WordPress database error Duplicate column name ‘comment_subscribe_optin_mailed’ for query ALTER TABLE wp_comments ADD COLUMN comment_subscribe_optin_mailed enum(‘Y’,’N’) NOT NULL default ‘N’ made by require, require_once, do_action, call_user_func_array, lcp_output_js, include, comment_form, do_action, call_user_func_array, show_subscription_checkbox, sg_subscribe_start, sg_subscribe->sg_subscribe, sg_subscribe->db_upgrade_check



    Forum Moderator

    Do you have a recent database backup?

    Yes, I have backups. The problem went away, however, without my doing anything.

    Hi, I’m having the same problem – categories and tags have disappeared for no reason…but they won’t come back.

    As above, the Admin interface for Categories says “96” entries, but the list has “no items found.” Also, my “Most Used” categories list still exists, but is seemingly useless.

    Any ideas?

    This can be caused by the /tmp directory on the server hosting MySQL being full. I think in my case it was caused by file system errors on the SAN, since I know there were disk problems at the time.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Categories, links and tags disappeared’ is closed to new replies.