Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

wp Tracking or counter plugin not work #521

Open
SiberMedya opened this issue Dec 31, 2024 · 1 comment
Open

wp Tracking or counter plugin not work #521

SiberMedya opened this issue Dec 31, 2024 · 1 comment

Comments

@SiberMedya
Copy link

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

WordPress database error [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'count'. Code - 102 for query SELECT SQL_NO_CACHE SUM(count) FROM wp_advads_clicks WHERE ad_id = 101; made by do_action('wp_ajax_nopriv_aa-server-select'), WP_Hook->do_action, WP_Hook->apply_filters, Advanced_Ads_Pro_Module_Ad_Server->get_placement, Advanced_Ads_Pro_Module_Ad_Server->get_placement_output_by_public_slug, Advanced_Ads_Placements::output, Advanced_Ads_Select->get_ad_by_method, Advanced_Ads_Select->get_ad_by_group, Advanced_Ads_Group->output, Advanced_Ads_Select->get_ad_by_method, Advanced_Ads_Select->get_ad_by_id, apply_filters('advanced-ads-ad-select-override-by-ad'), WP_Hook->apply_filters, Advanced_Ads_Pro_Module_Ads_For_Adblockers->override_ad_select_by_ad, Advanced_Ads_Ad->can_display, apply_filters('advanced-ads-can-display'), WP_Hook->apply_filters, Advanced_Ads_Tracking->can_display, Advanced_Ads_Tracking_Limiter->__construct, Advanced_Ads_Tracking_Limiter->migrate, Advanced_Ads_Tracking_Limiter->get_pace, Advanced_Ads_Tracking_Limiter->set_pace, Advanced_Ads_Tracking_Limiter->get_sums, Advanced_Ads_Tracking_Util->get_sums_for_ad

@SiberMedya
Copy link
Author

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 LIKE 'advanced_ads' AND ((wp_posts.post_status = 'publish'))
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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant