WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Categories, links and tags disappeared (6 posts)

  1. kwdavids
    Member
    Posted 2 years ago #

    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

  2. kwdavids
    Member
    Posted 2 years ago #

    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 t.name 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

  3. esmi
    Forum Moderator
    Posted 2 years ago #

    Do you have a recent database backup?

  4. kwdavids
    Member
    Posted 2 years ago #

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

  5. causeway
    Member
    Posted 2 years ago #

    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?

  6. kwdavids
    Member
    Posted 2 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic