I’m getting a number of database errors from this plugin. Here are two of the recent unique errors:<\/p>\n
Note: I’m using version 1.0.61 of Wats Premium.<\/p>\n","protected":false},"template":"","class_list":["post-8699612","topic","type-topic","status-publish","hentry","topic-tag-database","topic-tag-where"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/8699612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/8699612\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=8699612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}WordPress database error Unknown column 'post_type' in 'where clause' for query SELECT wp_comments.* FROM wp_comments WHERE comment_post_ID = '3149' AND comment_approved = '1' AND post_type != 'ticket' ORDER BY comment_date_gmt DESC LIMIT 10 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts<\/code>
\nIt looks like wats_filter_comments_rss<\/code> is appending a where clause without knowing what’s being queried. In the case of the error, we’re querying the comments table, not the posts table.<\/p>\nWordPress database error Unknown column 'wp_comments.comment_date_gmt' in 'where clause' for query SELECT wp1.comment_ID FROM wp_comments AS wp1 LEFT JOIN wp_posts AS wp3 ON wp1.comment_post_id = wp3.ID WHERE ( wp1.comment_approved = '1' ) AND wp1.comment_post_ID = 39282 AND ( \\n wp_comments.comment_date_gmt < '2017-01-25 22:30:12'\\n) AND wp3.post_status = 'publish' AND NOT EXISTS (SELECT * FROM wp_commentmeta AS wp2 WHERE wp1.comment_ID = wp2.comment_id AND wp2.meta_key = 'wats_internal_update' AND wp2.meta_value = 1) ORDER BY wp1.comment_date_gmt DESC made by require('wp-blog-header.php'), require_once('wp-includes\/template-loader.php'), do_feed, do_action('do_feed_rss2'), WP_Hook->do_action, WP_Hook->apply_filters, do_feed_rss2, load_template, require_once('wp-includes\/feed-rss2-comments.php'), comment_link, get_comment_link, get_page_of_comment, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query->get_comment_ids<\/code>
\nIt looks like there’s some code to replace wp_comments.comment_date_gmt<\/code> with wp1.comment_date_gmt<\/code>, but it’s not catching this query.<\/p>\n