{"id":4637265,"date":"2014-02-21T22:54:31","date_gmt":"2014-02-21T22:54:31","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/error-334\/"},"modified":"2016-08-21T16:34:18","modified_gmt":"2016-08-21T16:34:18","slug":"error-334","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/error-334\/","title":{"rendered":"error"},"content":{"rendered":"<p>get this error when using the radius search:<\/p>\n<p>Search<\/p>\n<p>SELECT SQL_CALC_FOUND_ROWS wp_posts.*, ( 3959 * acos( cos( radians(36.835238) ) * cos( radians( latitude.meta_value ) ) * cos( radians( longitude.meta_value ) &#8211; 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 = &#8216;_bbptl_lat&#8217; LEFT JOIN wp_postmeta longitude on longitude.post_id = wp_posts.ID and longitude.meta_key = &#8216;_bbptl_lng&#8217; WHERE 1=1 AND wp_posts.post_type = &#8216;topic&#8217; AND (wp_posts.post_status = &#8216;publish&#8217; OR wp_posts.post_status = &#8216;closed&#8217;) HAVING distance &lt;25 ORDER BY wp_posts.post_date DESC LIMIT 0, 15<\/p>\n<p>even on your site http:\/\/sandbox.pencil2d.org\/forums\/search\/?bbp_search=&amp;bbptl_search_addr=201+High+Street%2C+Portsmouth%2C+VA+23704%2C+USA&amp;bbptl_search_dist=25<\/p>\n<p>https:\/\/wordpress.org\/plugins\/bbpress-topic-location\/<\/p>\n","protected":false},"template":"","class_list":["post-4637265","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4637265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4637265\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4637265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}