WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: WP-RecentComments] Error on Widget display (4 posts)

  1. Robert S
    Member
    Posted 5 years ago #

    Hi,

    I am able to activate the plugin OK and then add and configure the Widget. But when displaying recent comments I get the following error:

    WordPress database error: [Table '....wp_users' doesn't exist]

    It would appear that your plugin does take into account WP alternative Table prefixes.

    R

  2. mg12
    Member
    Posted 5 years ago #

    Hi rschilt
    Thanks for your report. this bug will got fixed today.

  3. Robert S
    Member
    Posted 5 years ago #

    Hi,

    Thanks for responding and fixing that issue.

    Have fired up and all seems to be working great!

    Just one thing.... it does not seem to be excluding my comments and I'm setup as an administrator. Any reason you might be aware why the plugin would be behaving this way?

    R

  4. Alan.Guggenheim
    Member
    Posted 4 years ago #

    I am getting a lot of errors in my error_log file:
    [04-Oct-2009 00:13:13] WordPress database error Column 'post_status' in where clause is ambiguous for query SELECT DISTINCT wp_comments.* FROM wp_comments 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' 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 ('6') WHERE ( ( wp_posts.post_type = 'post' AND ( ( post_status IN ('private', 'publish') AND ( ( ( ( 1=1 ) OR ( wp_posts.post_author = '3' ) ) ) ) ) ) ) OR ( wp_posts.post_type = 'page' AND ( ( post_status IN ('private', 'publish') AND ( ( ( ( ( ( 1=1 AND wp_posts.ID NOT IN ('2663', '2083', '3095') ) ) OR ( ( uro.role_type = 'rs' AND uro.role_name IN ('private_page_reader') ) ) OR ( ( 1=1 AND wp_posts.ID NOT IN ('2083') ) ) ) OR ( wp_posts.post_author = '3' ) ) ) ) ) ) ) OR ( wp_posts.post_type = 'attachment' AND parent.post_type = 'post' AND ( ( post_status IN ('private', 'publish') AND ( ( ( ( 1=1 ) OR ( parent.post_author = '3' ) ) ) ) ) ) ) OR ( wp_posts.post_type = 'attachment' AND parent.post_type = 'page' AND ( ( post_status IN ('private', 'publish') AND ( ( ( ( ( ( 1=1 AND parent.ID NOT IN ('2663', '2083', '3095') ) ) OR ( ( uro.role_type = 'rs' AND uro.role_name IN ('private_page_reader') ) ) OR ( ( 1=1 AND parent.ID NOT IN ('2083') ) ) ) OR ( parent.post_author = '3' ) ) ) ) ) ) ) ) AND comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 15 made by require, require_once, include, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Comments->widget

Topic Closed

This topic has been closed to new replies.

About this Topic