Support » Fixing WordPress » blog_categories vanished?

  • Reposting as I posted in the wrong section by accident…

    So I’ve been having some small issues with a PHP5 changeover today and I just ran into a big one. I have no categories tab in my admin, nor can I select any categories when writing a post. It appears my table blog_categories has gone home. Any idea how this might have happened? Is there any issue known? All of our backups and the host backups seem to lack the table as well, which is odd because I was able to access it yesterday.

    Here is the exact error:

    WordPress database error: [Table ‘hojpodge_wordpress.blog_categories’ doesn’t exist]
    SELECT cat_ID FROM blog_categories WHERE category_parent = 0 AND ( link_count = 0 OR category_count != 0 OR ( link_count = 0 AND category_count = 0 ) ) ORDER BY category_count DESC

Viewing 5 replies - 1 through 5 (of 5 total)
  • Any idea how this might have happened?

    Yes. You upgraded to 2.3. Plugins or themes that accessed the categories table directly will need to be updated.

    Also, note that several template tags that deal with categories have been deprecated (dropped) and will need to be changed in your theme:

    http://codex.wordpress.org/Template_Tags#Category_tags

    Thread Starter dd0

    (@dd0)

    This didn’t happen when I upgraded to 2.3 though. Would something, say PHP5, help to cause the problem? I’m just wondering cause as I said I could access the categories yesterday, but I upgraded when 2.3 was released.

    Thread Starter dd0

    (@dd0)

    Fatal error: Call to undefined function _get_category_hierarchy() in /home/hojpodge/www/www/wp-admin/admin-functions.php on line 780

    Is in my categories admin. I assume that is a plugin causing the error? None of my plugins need an update, so I’m a bit lost.

    Sorry if I’m off-target here but…

    /home/hojpodge/www/www/wp-admin/admin-functions.php

    is /home/hojpodge/www/www/wp-admin/ the correct path?

    Thread Starter dd0

    (@dd0)

    Ya its just the default root my host has set. The first www basically doesn’t exist. I’ve never inquired as to why they have it set like that.

    I figure out the issue, apparently I had mixed WP versions. I don’t know how it happened as I uploaded the 2.3.1 zip and extracted. Anyways, a clean reinstall fixed it.

    Oh and ICDsoft is my host, they have the most amazing support staff I’ve ever encountered. Normally I wouldn’t tout them, but I encountered so many problems today with a PHP5 changeover. They went above and beyond to help with with a 3rd party program. Pretty amazing to see support that knowledgeable and willing to go the distance.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘blog_categories vanished?’ is closed to new replies.