error
-
get this error when using the radius search:
Search
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, ( 3959 * acos( cos( radians(36.835238) ) * cos( radians( latitude.meta_value ) ) * cos( radians( longitude.meta_value ) – radians(-76.2975306) ) + sin( radians(36.835238) ) * sin( radians( latitude.meta_value ) ) ) ) AS distance FROM wp_posts LEFT JOIN wp_postmeta latitude on latitude.post_id = wp_posts.ID and latitude.meta_key = ‘_bbptl_lat’ LEFT JOIN wp_postmeta longitude on longitude.post_id = wp_posts.ID and longitude.meta_key = ‘_bbptl_lng’ WHERE 1=1 AND wp_posts.post_type = ‘topic’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘closed’) HAVING distance <25 ORDER BY wp_posts.post_date DESC LIMIT 0, 15
even on your site http://sandbox.pencil2d.org/forums/search/?bbp_search=&bbptl_search_addr=201+High+Street%2C+Portsmouth%2C+VA+23704%2C+USA&bbptl_search_dist=25
The topic ‘error’ is closed to new replies.