Rodney Chatman

Not sure what you mean. Can you elaborate a bit?

Okay, looks as if it’s a browser issue on my end. Should the listings below the map update when the category changes? (capture2.png)

Ignore, the most recent update fixed this issue for me.

Seeing as how I’ve been messing around with

overall_rating

I think it bears on this current conversation. Not sure what I did, I am sure that I did it! This error happens with every review submitted for a listing and overall ratings stars don’t light up. Any idea?

[02-Mar-2019 04:27:23 UTC] WordPress database error Unknown column 'overall_rating' in 'field list' for query SELECT ratings, rating_count, overall_rating FROM aa8_geodir_gd_business_detail WHERE post_id = 13672 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/kleo/page.php'), get_template_part, locate_template, load_template, require('/themes/kleo/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, GeoDir_Template_Loader::setup_singular_page, do_shortcode, preg_replace_callback, do_shortcode_tag, WP_Super_Duper->shortcode_output, GeoDir_Widget_Single_Tabs->output, GeoDir_Widget_Single_Tabs->tab_content, comments_template, require('/plugins/geodirectory/templates/reviews.php'), do_action('geodir_after_review_list_title'), WP_Hook->do_action, WP_Hook->apply_filters, GeoDir_Review_Rating_Manager_Public->show_overall_multiratings, geodir_reviewrating_get_post_rating
[02-Mar-2019 04:28:56 UTC] WordPress database error Unknown column 'overall_rating' in 'field list' for query UPDATE 
aa8_geodir_gd_business_detail
 SET 
overall_rating
 = 2.973684, 
rating_count
 = 38 WHERE 
post_id
 = 13672 made by wp_handle_comment_submission, wp_new_comment, do_action('comment_post'), WP_Hook->do_action, WP_Hook->apply_filters, GeoDir_Comments::save_rating, GeoDir_Comments::update_post_rating

[02-Mar-2019 04:28:56 UTC] WordPress database error Unknown column 'overall_rating' in 'field list' for query UPDATE 
aa8_geodir_gd_business_detail
 SET 
overall_rating
 = 2.973684, 
rating_count
 = 38 WHERE 
post_id
 = 13672 made by wp_handle_comment_submission, wp_new_comment, do_action('comment_post'), WP_Hook->do_action, WP_Hook->apply_filters, GeoDir_Review_Rating_Manager_Public->geodir_reviewrating_save_rating, geodir_reviewrating_update_postrating, geodir_reviewrating_update_postrating_all, geodir_update_postrating, GeoDir_Comments::update_post_rating

[02-Mar-2019 04:28:56 UTC] WordPress database error Unknown column 'overall_rating' in 'field list' for query UPDATE 
aa8_geodir_gd_business_detail
 SET 
overall_rating
 = 2.973684, 
rating_count
 = 38 WHERE 
post_id
 = 13672 made by wp_handle_comment_submission, wp_new_comment, do_action('comment_post'), WP_Hook->do_action, WP_Hook->apply_filters, geodir_reviewrating_save_rating_func, geodir_reviewrating_update_postrating, geodir_reviewrating_update_postrating_all, geodir_update_postrating, GeoDir_Comments::update_post_rating

[02-Mar-2019 04:28:58 UTC] WordPress database error Unknown column 'overall_rating' in 'field list' for query SELECT ratings, rating_count, overall_rating FROM aa8_geodir_gd_business_detail WHERE post_id = 13672 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/kleo/page.php'), get_template_part, locate_template, load_template, require('/themes/kleo/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, GeoDir_Template_Loader::setup_singular_page, do_shortcode, preg_replace_callback, do_shortcode_tag, WP_Super_Duper->shortcode_output, GeoDir_Widget_Single_Tabs->output, GeoDir_Widget_Single_Tabs->tab_content, comments_template, require('/plugins/geodirectory/templates/reviews.php'), do_action('geodir_after_review_list_title'), WP_Hook->do_action, WP_Hook->apply_filters, GeoDir_Review_Rating_Manager_Public->show_overall_multiratings, geodir_reviewrating_get_post_rating

		
	

Thanks for you assistance. I was able to get things right using the shortcode builder, very handy tool. Is there a way to reference a listings overall or average star rating via a key?

Here’s what I currently have, see attached screenshot

[gd_post_badge key="post_date" condition="is_less_than" match="+30" badge='<i class="fas fa-check-circle"></i>New Listing' bg_color="#ff8040" txt_color="#ffffff" size="small" alignment="right" css_class="new"]

[gd_post_badge key="featured" condition="is_not_empty" badge='<i class="fas fa-certificate"></i>Featured' bg_color="#ff8040" txt_color="#ffffff" size="small" alignment="right" css_class="featured"]

[gd_post_badge key="claimed" condition="is_not_empty" badge='<i class="fas fa-check-circle"></i>Verified' bg_color="#ff8040" txt_color="#ffffff" size="small" alignment="right" css_class="verified"]

[gd_post_badge key="claimed" condition="is_empty" badge='<i class="far fa-question-circle"></i>Unclaimed' bg_color="#ff8040" txt_color="#ffffff" size="small" alignment="right" css_class="unverified"]

Hello,

This is the code I am using for ‘Featured’ and ‘New Listing’ (less than 30 days old) the Featured badge is showing but not using the font awesome icons. The ‘New Listing’ badge isn’t showing at all.

[gd_archive_item_section type='open' position='left']
[gd_post_images type='image' ajax_load='true' link_to='post' show_logo='true'][gd_archive_item_section type='close' position='left']
[gd_archive_item_section type='open' position='right']
[gd_post_title tag='h2']

<em>[gd_post_badge key="post_date" condition="is_less_than" match="+30" <i class="fas fa-star" aria-hidden="true"></i>New Listing' bg_color="#ff8040" txt_color="#ffffff" size="small" alignment="right" css_class="new"]

[gd_post_badge key="featured" condition="is_not_empty" <i class="fas fa-star" aria-hidden="true"></i>Featured' bg_color="#ff8040" txt_color="#ffffff" size="small" alignment="right" css_class="featured"]</em>

[gd_author_actions author_page_only='1']
[gd_post_distance]
[gd_post_rating alignment='left' ]

[gd_post_fav show='' alignment='right' ]
[gd_post_meta key='business_hours' location='listing']
[gd_output_location location='listing']
[gd_post_meta key='post_content' show='value-strip']
[gd_archive_item_section type='close' position='right']