Hi,

I am getting the following error since recently updating Role Scoper. It is similar to an error I used to get related to Role Scoper which Kevin expertly solved with a previous update. I'm hoping this can be resolved quickly too. Thanks for your help on this.

The error reads as follows:

[03-Sep-2010 02:36:07] WordPress database error Not unique table/alias: 'wp_posts' for query SELECT DISTINCT * FROM wp_posts INNER JOIN wp_comments ON wp_posts.ID = wp_comments.comment_post_ID INNER JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID LEFT JOIN wp_posts as parent ON parent.ID = wp_posts.post_parent AND parent.post_type IN ('post', 'page') AND wp_posts.post_type = 'attachment' WHERE  ( ( wp_posts.post_type = 'post'  AND (  ( wp_posts.post_status = 'publish' AND (  (  (  (  (  (  (  (  ( wp_posts.ID IN ( SELECT tr.object_id FROM wp_term_relationships AS tr WHERE tr.term_taxonomy_id IN ('3', '4', '21', '6', '7', '9', '10', '168', '12', '20', '22', '23', '25', '30', '31', '33', '34', '35', '37', '39', '40', '42', '103', '107', '119', '120', '134', '135', '137', '138', '140', '141', '144', '145', '146', '147', '152', '153', '154', '155', '156', '167', '165', '166', '169', '174', '191', '232', '260', '261', '262', '270', '276', '287', '296', '301', '324', '325', '326', '327', '329', '369', '370', '379', '380', '381', '385', '386', '391', '401', '420', '423', '424', '430')  )  )  )  )  )  )  )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'page'  AND (  ( wp_posts.post_status = 'publish' AND (  (  (  (  (  (  ( 1=1  AND wp_posts.ID NOT IN ('216', '316', '1733', '2934') )  )  )  )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'attachment' AND parent.post_type = 'post'  AND (  ( parent.post_status = 'publish' AND (  (  (  (  (  (  (  (  ( parent.ID IN ( SELECT tr.object_id FROM wp_term_relationships AS tr WHERE tr.term_taxonomy_id IN ('3', '4', '21', '6', '7', '9', '10', '168', '12', '20', '22', '23', '25', '30', '31', '33', '34', '35', '37', '39', '40', '42', '103', '107', '119', '120', '134', '135', '137', '138', '140', '141', '144', '145', '146', '147', '152', '153', '154', '155', '156', '167', '165', '166', '169', '174', '191', '232', '260', '261', '262', '270', '276', '287', '296', '301', '324', '325', '326', '327', '329', '369', '370', '379', '380', '381', '385', '386', '391', '401', '420', '423', '424', '430')  )  )  )  )  )  )  )  )  )  ) ) ) ) OR ( wp_posts.post_type = 'attachment' AND parent.post_type = 'page'  AND (  ( parent.post_status = 'publish' AND (  (  (  (  (  (  ( 1=1  AND parent.ID NOT IN ('216', '316', '1733', '2934') )  )  )  )  )  )  ) ) ) ) ) AND comment_approved = '1' AND comment_type = '' AND post_date < '2010-09-02 19:36:07' AND 1=1 AND wp_posts.post_status = 'publish' AND post_password = '' ORDER  BY comment_date DESC LIMIT 10 made by require, require_once, include, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, stats_page_shortcode, stats_page, get_recentcomments