This report involves two primary issues. The bigger issue is in the MySQL 8 conflict and is being resolved. We are still investigation the Settings Reset issue.
Settings Reset To Default
Some user settings (noted below) are not the same as they were originally on the production server after the 2502 update. This is still being investigated.
See https://internal.storelocatorplus.com/settings-reset-to-default/
Rank Field Conflict With MySQL 8
MySQL added the work “rank” as a reserved word. This conflicts with our Professional an Enterprise feature that has used rank as a standard field name for a decade. Turns out we missed on location where we need to specially mark this field in the data query.
See https://internal.storelocatorplus.com/mysql-8-rank-field-conflict/
User Report
The map is not working, and the pins are not showing up. Please let me know what happened. Thanks! We need to fix this ASAP.
Account: uws_at_*_dot_com
Account Level: Professional
Status: active
Expires: 2025-02-26 04:39:09
Versions:
SLP: 2502.21.01
myslp-dashboard-options: 2502.24.01
slp-premier-options: N/A
slp-power: 2502.18.01
slp-experience: 2502.20.01Dev Notes
UID: 720
SID: 718
Generate Embed: No locations found
There are locations in the database.
Map is centered in the USA.
Original Settings
As pulled from the original data store 25/02/23 1130A EST
csl-slplus-options
a:28:{
s:13:"ignore_radius";s:1:"0";
s:10:"map_domain";s:15:"maps.google.com";
s:11:"no_autozoom";s:1:"0";
s:13:"distance_unit";s:5:"miles";s:14:"dropdown_style";s:4:"none";
s:10:"map_center";s:13:"United States";
s:14:"map_center_lat";s:8:"37.09024";
s:14:"map_center_lng";s:12:"-95.71289100";
s:10:"zoom_level";s:2:"11";
s:10:"zoom_tweak";s:1:"0";s:8:"map_type";s:7:"roadmap";s:12:"bubblelayout";s:1363:"<div id="slp_info_bubble_[slp_location id]" class="slp_info_bubble [slp_location featured]"> <span id="slp_bubble_name"><strong>[slp_location name suffix br]</strong></span><span id="slp_bubble_directions">[html br ifset directions] [slp_option label_directions wrap directions]</span> <span id="slp_bubble_website">[html br ifset url][slp_location web_link][html br ifset url]</span> <span id="slp_bubble_email">[slp_location email wrap mailto ][slp_option label_email ifset email][html closing_anchor ifset email][html br ifset email]</span> <span id="slp_bubble_phone">[html br ifset phone] <span class="location_detail_label">[slp_option label_phone ifset phone]</span>[slp_location phone suffix br]</span> <span id="slp_bubble_fax"><span class="location_detail_label">[slp_option label_fax ifset fax ]</span>[slp_location fax suffix br]<span> <span id="slp_bubble_description"><span id="slp_bubble_description">[html br ifset description] [slp_location description raw]</span>[html br ifset description]</span> <span id="slp_bubble_hours">[html br ifset hours] <span class="location_detail_label">[slp_option label_hours ifset hours]</span> <span class="location_detail_hours">[slp_location hours suffix br]</span></span> <span id="slp_bubble_img">[html br ifset img] [slp_location image wrap img]</span> <span id="slp_tags">[slp_location tags]</span> </div>";
s:13:"map_home_icon";s:149:"https://dashboard.storelocatorplus.com/uws_at_*_dot_com/wp-content/mu-plugins/store-locator-le/images/icons/shape_lightblue_man.png";
s:12:"map_end_icon";s:107:"https://www.skedaddlewildlife.com/wp-content/themes/salcode-bootstrap-genesis/images/icons/sked-map-pin.png";
s:26:"immediately_show_locations";s:1:"1";
s:14:"initial_radius";s:5:"15000";
s:17:"loading_indicator";s:0:"";s:13:"resultslayout";s:2110:"<div id="slp_results_[slp_location id]" class="results_entry scroll_to_map location_primary [slp_location featured]"> <div class="results_row_left_column" id="slp_left_cell_[slp_location id]" > [slp_addon section=primary position=first] <span class="location_name">[slp_location name] [slp_location uml_buttons] [slp_location gfi_buttons]</span> <span class="location_distance">[slp_location distance_1] [slp_location distance_unit]</span> [slp_addon section=primary position=last] </div> <div class="results_row_center_column location_secondary" id="slp_center_cell_[slp_location id]" > [slp_addon section=secondary position=first] <span class="slp_result_address slp_result_street">[slp_location address]</span> <span class="slp_result_address slp_result_street2">[slp_location address2]</span> <span class="slp_result_address slp_result_citystatezip">[slp_location city_state_zip]</span> <span class="slp_result_address slp_result_country">[slp_location country]</span> <div class="contact_info"> <span class="slp_result_address slp_result_phone">[slp_location phone]</span> <span class="slp_result_address slp_result_fax">[slp_location fax]</span> </div> [slp_addon section=secondary position=last] </div> <div class="results_row_right_column location_tertiary" id="slp_right_cell_[slp_location id]" > [slp_addon section=tertiary position=first] <div class="online_info"> <span class="slp_result_contact slp_result_website">[slp_location web_link]</span> <span class="slp_result_contact slp_result_email">[slp_location email_link]</span> <span class="slp_result_contact slp_result_directions"><a href="https://[slp_option map_domain]/maps?saddr=[slp_location search_address]&daddr=[slp_location location_address]" target="_blank" class="storelocatorlink">[slp_location directions_text]</a></span> </div> <span class="slp_result_contact slp_result_hours textblock">[slp_location hours]</span> [slp_location pro_tags] [slp_location iconarray wrap="fullspan"] [slp_location eventiconarray wrap="fullspan"] [slp_location socialiconarray wrap="fullspan"] [slp_addon section=tertiary position=last] </div> </div>";s:13:"label_website";s:7:"Website";s:16:"label_directions";s:10:"Directions";s:11:"label_email";s:5:"Email";s:11:"label_phone";s:5:"Phone";s:9:"label_fax";s:3:"Fax";s:16:"google_map_style";s:0:"";
s:20:"no_homeicon_at_start";s:1:"1";
s:16:"append_to_search";s:0:"";s:10:"use_sensor";s:1:"0";s:10:"use_nonces";s:1:"0";}