[Plugin: Bad Behavior] Error after upgrading to WordPress 2.6

  • I am having trouble with the Bad Behavior plug-in since I upgraded to WordPress version 2.6. Everything else that I did with the upgrade seemed to work, except for Bad Behaviour. I have even tried upgrading my version of Bad Behavior to 2.0.20 but whenever I activate it on my plugins page I get the following error at the top of my blog:

    WordPress database error: [Table ‘w2look_wrdp1.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)) + ‘-4’ 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 <= ‘2008-08-01 00:39:10’ GROUP BY p2c.category_id ORDER BY numposts DESC

    This error shows up at the top of my page right before my blog header whenever I activate Bad Behavior from my wordpress plugins page. As soon as I de-activate it. The error goes away.

    Is anyone else having a similar problem?

    Does anyone know how to fix this?

    I would prefer to have Bad Behavior activated for obvious reasons. All help is greatly appreciated.

Viewing 10 replies - 1 through 10 (of 10 total)

  • 0) What version of WP were you at before upgrading? Did you run the upgrade script afterwards?

    1) Does that table exist? (wp_post2cat)

    2) Are you running a current version of Bad Behavior?

    Thread Starter w2look

    (@w2look)

    I upgraded from WordPress version 2.0.

    I am currently running Bad behavior version 2.0.20.

    I de-activated all of my plugins and then ran the upgrade script afterwards. Everything worked just fine. I checked for the latest version of the plugins that I use (most had a one-click upgrade link) and re-activated them one by one.

    However, whenever I re-activate bad behavior, I get the error code above. I checked for the table wp_post2cat in phpMyAdmin and that table does not exist.

    Could this be due to the theme I am using?

    I don’t think it’s on the compatible list. Maybe I’ll try changing my theme to one on the list and see if it works. If you have another suggestion, I’d love to hear it before I go through the trouble of changing themes and re-writing CSS etc.

    My instinct would be to say it can’t possibly be related to the theme… but then again, since that table no longer needs to exist, perhaps it does.

    Try this: Just temporarily change to the Default theme.
    Activate Bad Behavior.
    Same problem?

    Thread Starter w2look

    (@w2look)

    Yes. In fact, I have completely switched themes and changed CSS.

    When I activate bad behavior I still get the error. My next guess is to completely delete bad behavior from my server, download a new copy of 2.0.20 and re-install it.

    I’ll let you know how it goes when I have the time to finish it.

    Thread Starter w2look

    (@w2look)

    Ok.

    I did a complete change-over to use the default theme, got my CSS in line to where my blog is displaying how I want it to, removed the entire instance of bad behavior from my server, re-downloaded bad behavior 2.0.20 and FTP’d it to my server.

    Re-activated it and got the same error message at the top of the page:

    ” [Table ‘w2look_wrdp1.wp_post2cat’ doesn’t exist]…etc.”

    However, this time, the bad behavior stats by-line was displayed in the footer of my blog and showed that Bad Behavior had blocked 110 access attempts in the last 7 days.

    I have no idea where this table wp_post2cat reference is coming from. When I looked at my databases using phpMyAdmin, I couldn’t find a table by that name anywhere and I don’t know why Bad Behavior is looking for it.

    I upgraded my other blog from WordPress 2.5 to 2.6 using the exact same steps and have had no problems whatsoever with Bad behavior.

    Can anyone out there offer me some help?

    Thread Starter w2look

    (@w2look)

    Bad Behavior recently released an updated version.

    I used the quick link in my wordpress dashboard to upgrade the plugin from version 2.0.20 to 2.0.22.

    I activated the plugin and I am still getting the same error.

    I can’t imagine where that error would be coming from. As another person mentioned, that table no longer exists. My guess is it’s another plugin you’re running that you need to update.

    Just chiming in to say that I have the same problem as well and am hoping to find a fix. Spam has gone up since removing Bad Behavior from the server due to this problem.

    https://www.ads-software.com/support/topic/135564?replies=101

    Looks like it’s an issue with some plugins using a call to wp_post2cat which no longer exists as of WordPress 2.3.

    I’m having this issue running WordPress 2.6.3 and Bad Behavior 2.0.24.

    Fix: Disable logging in Bad Behavior and it should then function normally without errors.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘[Plugin: Bad Behavior] Error after upgrading to WordPress 2.6’ is closed to new replies.