Categories disappearing… wasn't this fixed?

  • Resolved Will

    (@wlanni)


    14 years, 1 month ago

    Hello,

    Lots of old posts on here about categories disappearing from v2.6.

    I’ve seen a lot of solutions that indicate that this is probably a problem with the MySQL database unable to write to /tmp. I’ve sent off a mail to the hosting to have them give authorize my user so I can test that.

    However, I wanted to double check and see if anyone else is experiencing this with 3.0.4, and have discovered some other solutions (or causes).

    I was developing a thematic child theme, pretty heavily. I’ve switched back to the default twentyten, turned off all plugins. I can see the category names in phpMyAdmin, and even went as far as backing up, creating a new database, and restoring to it. Nada. I have added a categories widget to the sidebar to see if that would trigger it, and attempted to rename the categories by forcing the url to the category edit page. Still not working.

    Absolutely no categories showing up in the wp-admin categories panel.

    Anyone have any further ideas?

    https://www.revebeds.com/home-dev

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Will

    (@wlanni)

    Oh one other thing: I set the permalinks to default, and I’m finding that none of the urls are pointing correctly to the pages. They all wind up just showing the temp html home page I created while developing the site. That is really kinda odd too.

    Thread Starter Will

    (@wlanni)

    OK, just wanted to update this.

    This is definitely a problem of the MySQL database not being able to write to the /tmp folder on the webhost.

    Here’s an entry from the error log off the server:
    [01-Feb-2011 02:07:05] WordPress database error Can't create/write to file '/tmp/#sql_ffc_0.MYI' (Errcode: 28) for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (60) ORDER BY t.name ASC made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms

    So the solution? I have no idea, as I’m no server guru. I’m in contact with my webhost support to see if there’s something we can do about having the database user having rights to write to that directory.

    However, having them clear out /tmp resolves the problem temporarily.

    So, if you run into this, get in contact with your webhost to make sure that the database can write to the /tmp folder.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Categories disappearing… wasn't this fixed?’ is closed to new replies.