I have WP 2.8 - I just installed the ROle Scoper plugin. It all works well, except for one thing. I have not chnaged any settings after activating the plugin.

The only problem that I have found is the when a contributor logs in and views the dashboard page, right at the bottom of the page, it displays the following error:

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN wp_term_relationships AS tr ON wp_posts.ID = tr.object for query SELECT DISTINCT wp_comments.* FROM wp_comments INNER JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID ORDER BY comment_date_gmt DESC LIMIT 0, LEFT JOIN wp_term_relationships AS tr ON wp_posts.ID = tr.object_id LEFT JOIN wp_user2role2object_rs AS uro ON uro.obj_or_term_id = wp_posts.ID AND uro.src_or_tx_name = 'post' AND uro.scope = 'object' AND uro.assign_for IN ('entity', 'both') AND uro.group_id IN ('4') WHERE 1=1 AND ( ( post_status IN ('private', 'draft', 'future', 'pending', 'publish') AND ( ( ( wp_posts.post_type = 'post' AND ( ( ( 1=2 ) ) ) ) ) OR ( ( wp_posts.post_type = 'page' AND ( ( ( 1=2 ) ) ) ) ) ) ) ) 50 made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_recent_comments, apply_filters, call_user_func_array, scoperadminhardway_ltd->flt_last_resort_query, scoper_get_results, scoper_db_method, call_user_func WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN wp_term_relationships AS tr ON wp_posts.ID = tr.object for query SELECT DISTINCT wp_comments.* FROM wp_comments INNER JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID ORDER BY comment_date_gmt DESC LIMIT 0, LEFT JOIN wp_term_relationships AS tr ON wp_posts.ID = tr.object_id LEFT JOIN wp_user2role2object_rs AS uro ON uro.obj_or_term_id = wp_posts.ID AND uro.src_or_tx_name = 'post' AND uro.scope = 'object' AND uro.assign_for IN ('entity', 'both') AND uro.group_id IN ('4') WHERE 1=1 AND ( ( post_status IN ('private', 'draft', 'future', 'pending', 'publish') AND ( ( ( wp_posts.post_type = 'post' AND ( ( ( 1=2 ) ) ) ) ) OR ( ( wp_posts.post_type = 'page' AND ( ( ( 1=2 ) ) ) ) ) ) ) ) 50 made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_recent_comments

This error does not show up in the admin dashboard.

Even though there is this error, everything still seems to work fine.