Reply To: Locations Not Showing Up After Update?

Home Forums Store Locator Plus Locations Not Showing Up After Update? Reply To: Locations Not Showing Up After Update?

#29267

Lance Cleveland
Keymaster

@haley, I’ve tried several searches.   It appears you have opted for a hidden Pro Pack tag field of “Country” to be required.

 

That means all of your locations MUST have the word “country” in the tag field.

 

This is the response from your server when looking for locations within 500 miles of 29464 (Mount Pleasant SC):

SELECT *,( ‘3959’ * acos( cos( radians(‘32.8234848’) ) * cos( radians( sl_latitude ) ) * cos( radians( sl_longitude ) – radians(‘-79.85208180000001’) ) + sin( radians(‘32.8234848’) ) * sin( radians( sl_latitude ) ) ) ) AS sl_distance  FROM redesign_wp_store_locator  LEFT JOIN redesign_wp_slp_extendo USING(sl_id)  WHERE   sl_latitude REGEXP ‘^[0-9]|-‘ AND sl_longitude REGEXP ‘^[0-9]|-‘  AND  ( NOT sl_private OR sl_private IS NULL)   AND ( sl_tags LIKE ‘%Country%’)  HAVING (sl_distance < 500.000000) OR (sl_distance IS NULL)  OR (featured = 1)  ORDER BY sl_distance asc LIMIT 25

 

In English:

 

Get all locations within 500 miles of the lat/long for Mount Pleasant SC that are NOT PRIVATE and have “Country” in the tag field OR are marked as featured locations.