Support » Fixing WordPress » Solution for 2.3 database errors / wp_post2cat does not exist

  • If you are getting a database error like this:

    WordPress database error: [Table ‘wp_post2cat’ doesn’t exist]
    SELECT p2c.category_id AS cat_id, COUNT(p2c.rel_id) AS numposts, UNIX_TIMESTAMP(max(posts.post_date_gmt)) + ‘8’ AS last_post_date, UNIX_TIMESTAMP(max(posts.post_date_gmt)) AS last_post_date_gmt FROM wp_post2cat p2c INNER JOIN wp_posts posts ON p2c.post_id=posts.id WHERE 1 = 1 AND posts.post_type = ‘post’ AND posts.post_status = ‘publish’ AND posts.post_date_gmt <= ‘2007-09-19 12:08:25’ GROUP BY p2c.category_id ORDER BY numposts DESC

    or like this:

    WordPress database error: [Table ‘wordpress.wp_post2cat’ doesn’t exist]
    SELECT c.cat_name FROM wp_post2cat p2c INNER JOIN wp_categories c ON p2c.category_id = c.cat_id WHERE p2c.post_id = 218

    or like this:

    WordPress database error: [Table ‘wordpress.wp_post2cat’ doesn’t exist]
    SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = ‘publish’ GROUP BY cat_ID

    or any other database error which contains wp_post2cat or wp_categories, you are using a plugin or theme which is not compatible with WordPress 2.3.

    Example plugins which don’t work:

    It could also be that your theme is causing this error:

    Please double check before posting that you don’t use any incompatible plugins. A list of plugins that work and which won’t work can be found at the WordPress Codex.

Viewing 15 replies - 16 through 30 (of 100 total)
  • In many cases the non working themes are calling the database directly in the sidebar.php or header.php file in the template to get you list of catigories. wp-list-catigories is the tag that you wanna use to accomplish this effect.

    Otto, honestly I have no clue what your talking about. Like I said before, upgrading used to be easy. I do not now what an SQL querie is. Up to now all WP themes worked fine and some plugins did not work well together. I can understand that and this is the reason why I liked blogging with WordPress. So now I do not understand why the database broke down in my own blog, this upgrade round. I don’t know if it’s the theme or anything else…

    theenterprise17, I guess this won’t come as a plugin.

    P.S. even when I use a 2.3 ready theme (for example Silverlight) the database keeps broken…

    In my styles.css, I have #categories to tell the system that the sidebar format applies.

    However, in 2.3 Categories no longer exist. What should this keyword be replaced with?

    Thanks.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Up to now all WP themes worked fine and some plugins did not work well together. I can understand that and this is the reason why I liked blogging with WordPress.

    Not true, the 2.1 upgrade broke a lot of themes, as well as plugins.

    So now I do not understand why the database broke down in my own blog, this upgrade round. I don’t know if it’s the theme or anything else…

    And nobody can tell you that for certain either. We’re not you, we don’t have access to your site and setup. It might be a plugin, it might be the theme, but I cannot tell you because I’m not actually there, looking at your code.

    P.S. even when I use a 2.3 ready theme (for example Silverlight) the database keeps broken…

    Then maybe, just maybe, you’ve got an incompatible plugin? You know that you’re supposed to disable all plugins before an upgrade, right? Well, now you know why.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    However, in 2.3 Categories no longer exist. What should this keyword be replaced with?

    Categories still exist in 2.3. So it’s hard to know what you’re talking about. Your CSS doesn’t have anything to do with the database.

    Otto, I dropped all tables in MyPHP. Uploaded the backed-up database. Then re-run upgrade.php, and now voila everything seems fixed. All plugins were disabled, it must have been the conversion of the database. So glad I made a back up!

    http://deepthoughts.affinityenterprises.com/

    Deep Thoughts Categories no longer has the background formatting the other widgets have. I was instructed to go into “styles.css” and make sure I have #categories in the appropriate places.

    /*——-SIDEBAR———*/

    #sidebar {
    font-size:.9em;
    }

    #meta,
    #categories,
    #pages,
    #yammyamm-menu,
    #recent-posts,
    #recent-comments,
    #peters-date-countdown,
    #calendar,
    #scrobbler,
    #links,
    #text-1,
    #text-2,
    #linkcat-5,
    #archives,
    #linkcat-4,
    #linkcat-11,
    #google-search,
    #front-page-login,
    #rss-1,
    #rss-2,
    #dthoughts
    {
    background: #eee url(images/sideboxbg.gif) top left repeat-x;
    padding: 25x;
    margin: 5px;
    border: 1px solid #ddd;
    }

    However, #categories doesn’t seem to be working.

    Greetings: Wow, a lot of serious dedicated users got upset. what do you expect for free!

    All we did to get rid of the errors was in Arnee’s post…DISABLE ALL PLUGINS.

    We were lucky because we don’t use that many plugins, SpotMilk,CaptCha!,Kaccordion Multipack…

    We Forgot to disable all plugins on the upgrade yesterday, but after trying to post and getting the errors like Arnee said, we went back and disabled the ULTIMATE TAG WARRIOR, SIMPLE TAGS, and WP-SHORTSTAT…

    Yeah!! no more errors…

    Hope this helps. The DATABase error is not in the theme but in the plugins mentioned.

    In may case the MyDashboard plugin cause the database error. Since it’s gone everything is working fine again.

    I’m getting this error from the Popularity Contest plugin. Hope the author upgrades it as soon as possible.

    I received the WordPress database error in both the CopyBlogger and CutLine Themes.

    The cause was the SimpleTagging Plugin, version 1.6.8.1 which is supposed to be compatible with WordPress 2.3.

    I de-activated the plugin, error stopped, however now I don’t have any of my tags.

    My page tabs don’t work either now, 404 error, but I figure that may be something to do with the themes.

    I was not aware that SimpleTagging would work with 2.3

    http://trac.herewithme.fr/project/simpletagging/wiki/Limits%2C%20Known%20Issues

    upgrade ,just now~~
    🙂

    Well, I got some error lines too for wp2cat… after depluggin all and activating one bye one the plugin Jerome’s Keyword causes the problem

    “I was not aware that SimpleTagging would work with 2.3”

    SimpleTagging version 1.6.8.1, was offered as a new upgrade for 2.3 on my plugin page, which is why I installed it.

    Apprantly I should have taken a look at the compatibility page instead and saved myself a lot of work. 😉

Viewing 15 replies - 16 through 30 (of 100 total)
  • The topic ‘Solution for 2.3 database errors / wp_post2cat does not exist’ is closed to new replies.