Feeds, Pownce and WP 2.3 at Scattered

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.

Viewing 7 Comments

Alvar Hanso 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Select * from [more lost blog please]

Believe...

http://www.geocaching.com/seek/cache_details.as...

reply edit reblog flag record video comment

Jared 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

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.

reply edit reblog flag record video comment

http://freepressblog.org

Dan Cameron 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

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

reply edit reblog flag record video comment

http://dancameron.org

Jared 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

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.

reply edit reblog flag record video comment

http://freepressblog.org

Michael 12 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

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!

reply edit reblog flag record video comment

Jared 11 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

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.

reply edit reblog flag record video comment

http://freepressblog.org

Dr. Xu 9 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

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.

reply edit reblog flag record video comment

http://doc.ac.cn