-
-
Notifications
You must be signed in to change notification settings - Fork 138
Description
WordPress database error [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column 'wp_posts.post_author' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Code - 8120 for query SELECT wp_posts.*, imp.count as impressions, cl.count as clicks, cl.count / imp.count as ctr , wp_posts.post_title
FROM wp_posts LEFT JOIN (SELECT ad_id, SUM(count) as count from wp_advads_impressions GROUP BY wp_advads_impressions.ad_id) as imp ON wp_posts.ID = imp.ad_id LEFT JOIN (SELECT ad_id, SUM(count) as count from wp_advads_clicks GROUP BY wp_advads_clicks.ad_id) as cl ON imp.ad_id = cl.ad_id
WHERE 1=1 AND ((wp_posts.post_type = 'advanced_ads' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status LIKE 'future' OR wp_posts.post_status LIKE 'draft' OR wp_posts.post_status LIKE 'pending'
OR wp_posts.post_status LIKE 'private'
OR wp_posts.post_status LIKE 'advanced_ads_expired')))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_title ASC made by WP_Posts_List_Table->prepare_items, wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts