Feeds, Pownce and WP 2.3

So some of you might have noticed that my feeds are completely out of whack. Well since the upgrade to 2.3 some plugins that say they are 2.3 compatible aren’t working. However, I’m not completely sure it’s the plugins causing the issue because I’m getting similar errors this very second while writing this post.

The auto save produces this error every time I write a post, no matter what I do:

WordPress database error: [Table 'name.prefix_categories' doesn't exist]
SELECT c.cat_ID AS ID, MAX(p.post_modified) AS last_mod FROM `
prefix_categories` c, `prefix_post2cat` pc, `prefix_posts` p WHERE pc.category_id = c.cat_ID AND p.ID = pc.post_id AND p.post_status = 'publish' AND p.post_type='post' GROUP BY c.cat_id

I shouldn’t be getting these errors after the complete re-install I did this morning. I’ve been meaning to export the entire site through the export function WP provides and then loading that backup into a fresh installation for while, but this morning I was fed up so I just did it.

The syndication plugin is getting some similar errors that I can’t entirely explain how it happens, but the plugins I’ve used (I think) are creating posts with a dummy category name which is the same as the intended category. That makes me think the plugin just isn’t supported yet fully, even if it says it is on the plugin page but that doesn’t eplain the similar errors I’m getting on auto save.

I really don’t know what to do other then wait for 2.3.1 and hopefully some more updates from the plugin authors. For now all RSS readers wont be receiving my pownce posts, you’ll need to subscribe to them separately and will have to comment on Pownce.

This might be a good thing if it forces Jared, Nathan and Nate to create Pownce accounts in order to comment, that way I don’t have to pull in these posts at all.

About the Author, Dan Cameron:

I'm the owner and solution engineer at Sprout Venture, a web solutions company that specializes in web development including WordPress.

I started my first blog in 2003 and transitioned to WordPress in 2004. Since moving to WordPress I've written a few plugins and themes for public consumption. Lately I'm busy engineering/building/coding and have only been able to share a few code snippets.

If you're in need of some web development, web design or custom WordPress plugins and/or themes contact me, I'll be happy to discuss it with you.

Read More »

  • I did a fresh WP 2.3 Install and have the same problem only when using the theme ICE 3.17(http://milo.peety-passion.com/category/themes/), I think it's a plugin issue.
  • This is expected behavior, as the 2.3 upgrade drops the obsolete tables "categories", "link2cat", and "post2cat".

    They aren't used anymore, so any plugin that depends on them would be broken anyway.
  • Michael
    Hi there,
    upgraded today and have the very same problem. My updated 2.3 Wordpress doesnot have the _post2cat table. While two other pre 2.3 blogs have the table. The plugin that brakes the 2.3 is in my case the extended live archives plugin. Everytime I try to post I get the garbled output, but the messages are still posted. weird!
  • Yeah, I saw that, I was just confirming it, since if that's the case then it's 100% definitely a plugin related issue.

    It's definitely not the WordPress 2.3 code issuing that query, so therefore it must be a plugin.

    It could easily be related to auto-save via a plugin hook that fires whenever any post is saved.
  • "I shouldn’t be getting these errors after the complete re-install I did this morning. "

    That still doesn't explain the errors with auto-save. Unless that's another plugin incompatibility.
  • First, you did a fresh 2.3 install right? Because I remember that you mentioned an incomplete SVN upadte at some point.

    Assuming that's the case, and all your WP files are version 2.3, then the issue you outlined above is definitely a plugin issue, because there are no references to the post2cat table in any 2.3 code (I just checked), other than the upgrade routines, which copy some data out into the new taxonomy system and then drops those old category related tables.

    My best guess is that plugin authors may have tested their changes on a pre-release version of 2.3, because I don't think the upgrade routine was modified to drop the category tables until right before the 2.3 release. So I'm guessing that they tested (if they did, in fact, test their plugins) against a database that had not been run through the released version of the upgrade routine.

    As for pounce, I don't know about that. I'll have to think about it, but I'm extremely hesitant to sign up for yet another service.
  • Select * from [more lost blog please]

    Believe...

    http://www.geocaching.com/seek/cache_details.as...
blog comments powered by Disqus