Hi,

In the recent comments section of my blog's dashboard, I get a WordPress database error: [Unknown table 'wp_rs_ratings' in field list]

This error message is also shown when visiting the comments feed.

I'm using the latest version of the plugin, upgraded from the previous.

Any advice?

Thanks

Looks like the Bad Behaviour plugin was causing the error in the dashboard, but disabling it doesn't have any effect on the comments feed.

That table is created when you activate the plugin. Try deactivating and reactivating it.

I've tried deactivating and reactivating the plugin without any success.  I've also tried disabling all other plugins, but still the comments feed page gives me:

WordPress database error: [Unknown table 'wp_rs_ratings' in field list]

I've also tried to replicate the error on a separate WordPress installation with the same plugins (same versions too) and can't.

You can try creating the table yourself, through phpMyAdmin or connecting directly to MySQL with the client if you have it. Here's the SQL:

CREATE TABLE wp_rs_ratings (comment_id INT, rating_id INT, rating_value DOUBLE, PRIMARY KEY (comment_id, rating_id));

The table already existed and I've already got records in it.

It's okay now, I've narrowed it down to the Bad Behaviour plugin.  I've had to disable it a few times before it would completely release its grip.

Glad you worked it out. When I have a chance next week, I'll take a look at the Bad Behaviour code and see why it's conflicting with the query filters.