WordPress.org

Support

Support » How-To and Troubleshooting » Solution for 2.3 database errors / wp_post2cat does not exist

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)
  • theenterprise17
    Member

    @theenterprise17

    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.

    George
    Participant

    @george71

    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…

    AffinityEnterprises
    Member

    @affinityenterprises

    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.

    Samuel Wood (Otto)
    Keymaster

    @otto42

    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.

    Samuel Wood (Otto)
    Keymaster

    @otto42

    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.

    George
    Participant

    @george71

    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!

    AffinityEnterprises
    Member

    @affinityenterprises

    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.

    jollymoon
    Member

    @jollymoon

    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.

    Ferdinand
    Member

    @ferdinand

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

    mhdhallak
    Member

    @mhdhallak

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

    Sparrowhawk
    Member

    @sparrowhawk

    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.

    doc_holiday
    Member

    @doc_holiday

    I was not aware that SimpleTagging would work with 2.3

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

    rexsky
    Member

    @rexsky

    upgrade ,just now~~
    🙂

    patjepayer
    Member

    @patjepayer

    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

    Sparrowhawk
    Member

    @sparrowhawk

    “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.