Title: Database errors Last modified: January 26, 2017 --- # Database errors * Resolved [MikeNGarrett](https://wordpress.org/support/users/mikengarrett/) * (@mikengarrett) * [9 years, 2 months ago](https://wordpress.org/support/topic/database-errors-46/) * I’m getting a number of database errors from this plugin. Here are two of the recent unique errors: * `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` It looks like `wats_filter_comments_rss` 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. * `WordPress 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` It looks like there’s some code to replace `wp_comments.comment_date_gmt` with ` wp1.comment_date_gmt`, but it’s not catching this query. * Note: I’m using version 1.0.61 of Wats Premium. Viewing 3 replies - 1 through 3 (of 3 total) * Plugin Author [firebird75](https://wordpress.org/support/users/firebird75/) * (@firebird75) * [9 years, 2 months ago](https://wordpress.org/support/topic/database-errors-46/#post-8700226) * Hello Mike, * Can you please reach out to me via the official website contact form? I will be happy to provide premium support via that way. * Thanks! * [santoshsharma](https://wordpress.org/support/users/santoshsharma/) * (@santoshsharma) * [9 years, 2 months ago](https://wordpress.org/support/topic/database-errors-46/#post-8705316) * wpqh_users: Table ‘ufshrmid_wp503.wpqh_users’ doesn’t exist wpqh_usermeta: Table‘ ufshrmid_wp503.wpqh_usermeta’ doesn’t exist wpqh_posts: Table ‘ufshrmid_wp503. wpqh_posts’ doesn’t exist wpqh_comments: Table ‘ufshrmid_wp503.wpqh_comments’ doesn’t exist wpqh_links: Table ‘ufshrmid_wp503.wpqh_links’ doesn’t exist wpqh_options: Table ‘ufshrmid_wp503.wpqh_options’ doesn’t exist wpqh_postmeta: Table ‘ufshrmid_wp503. wpqh_postmeta’ doesn’t exist wpqh_terms: Table ‘ufshrmid_wp503.wpqh_terms’ doesn’t exist wpqh_term_taxonomy: Table ‘ufshrmid_wp503.wpqh_term_taxonomy’ doesn’t exist wpqh_term_relationships: Table ‘ufshrmid_wp503.wpqh_term_relationships’ doesn’t exist wpqh_commentmeta: Table ‘ufshrmid_wp503.wpqh_commentmeta’ doesn’t exist * Even after repairing frm PHPadmin still error is coming * Plugin Author [firebird75](https://wordpress.org/support/users/firebird75/) * (@firebird75) * [9 years, 2 months ago](https://wordpress.org/support/topic/database-errors-46/#post-8705346) * Hello, * Sorry but your error has nothing to do with WATS… This is a vanilla WordPress issue that you are having with your DB. Please open a new topic with WP general support forum to get assistance from the community. There is nothing I can do in WATS to fix your problem. Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘Database errors’ is closed to new replies. * ![](https://ps.w.org/wats/assets/icon-256x256.png?rev=980472) * [WP Advanced Ticket System, Elite Support Helpdesk](https://wordpress.org/plugins/wats/) * [Frequently Asked Questions](https://wordpress.org/plugins/wats/#faq) * [Support Threads](https://wordpress.org/support/plugin/wats/) * [Active Topics](https://wordpress.org/support/plugin/wats/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wats/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wats/reviews/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [where](https://wordpress.org/support/topic-tag/where/) * 3 replies * 3 participants * Last reply from: [firebird75](https://wordpress.org/support/users/firebird75/) * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/database-errors-46/#post-8705346) * Status: resolved