Fall 2023 Locator Updates

We have been busy catching up on some much-needed maintenance updates to the Store Locator Plus® family of plugins. While our SaaS service has been running smoothly, there have been several issues that needed to be addressed with the WordPress plugin versions. Some of the issues are related to changes in WordPress core with breaking changes — things they changed that no longer work the way they used to. Other issues, which have come up more recently are due to breaking changes in MySQL — specifically MySQL version 8 and higher.

Large File Imports : November Fall 2023 Locator Updates

Users of the Power add on that were importing large location files would run into issues if they were also using PHP 8.2 or higher. Large files are handed off to a background processor (cron jobs in Linux-speak) for WordPress to prevent browser time out and connection issues. Since larger files often take more than the 300 seconds most PHP servers configurations allow, Store Locator Plus® first uploads the file to the media library (usually takes less than 300 seconds even for large files) , the reads that file in chunks via an asynchronous cron process to ensure the entire file is processed even when the server says “you used up too much of your allowed time, we are shutting you off”.

Store Locator Plus® implemented this “chunk processing” years ago (2018 maybe?). After uploading a CSV file, Store Locator Plus® starts a timer in the background that runs every minute asking “did my file import finish?”. To do so, it keeps track of the import progress via meta tags associated with the media file stored in WordPress. These meta tags including things like how many lines were read, how many were processed, and other metrics that this timer can look at to determine if the entire file was processed. If not, it starts processing more of the file from where it left off. When it finishes the timer is deleted so the app does not keep taking up system resources.

Unfortunately a code patch in the 2310.XX updates disabled this cron process, which stopped all large files from importing. This has been resolved.

MySQL 8 Changes

Last month we updated the Store Locator Plus® WordPress versions to support MySQL 8 and higher. Turns out MySQL (not MariaDB, the open source and free counterpart many hosting services use — MariaDB still works as expected) decided to allocate the word “RANK” for their own internal use. This new “reserved word” happens to match a field name we have been using one of our add-ons for years. Now that field name breaks things for users running the “bona fide” Oracle version of MySQL 8 or higher. Thankfully there is a simple workaround which has been patched in the October Fall 2023 Locator Update.

Unfortunately, anyone that manually upgraded their MySQL version from pre-8 to 8+ probably broke things on their Store Locator Plus® installs; Especially if they decided to activate the location ranking feature after doing so. While generally a good idea to review things like breaking changes BEFORE upgrading a database engine, life it hectic and often the “upgrading is better, get it done” path takes precedence in these situations.

For users that upgraded the database and had an existing Store Locator Plus® installation, the data structures and related functionality for ranking will remain intact and work fine if all our plugins have been updated to 2310.XX or higher. If ranking was enabled AFTER the database was upgraded you may need to remove the wp_slp_extendo and wp_slp_extendo_meta tables, then re-install and re-activate the Experience add-on (you may also need to reset the WordPress meta that marks the current installed version of this plugin).

Anyone installing on a NEW installation of WordPress with Store Locator Plus® add ons for ranking locations likely ran into an issue before our 2310.XX version of the plugin. The best path forward here is to deactivate the Store Locator Plus® plugins, manually remove the related data tables (wp_slp_extendo, wp_slp_extendo_meta, wp_store_locator), and the entries from the wp_options table for SLP related settings (option_name like ‘%slp%’) to clear out any “cruft” before re-installing and re-activating the SLP plugins.

Fall 2023 Random Locator Updates

We’ve also been doing some clean up now that PHP 8 is in play on most servers. PHP 8 is far less forgiving, and yes, they too added breaking changes where the latest version no longer plays nice with code that worked perfectly fine in earlier versions. Multiple PHP 8 warnings have been cleaned up in the past month, though none will break the app it does create extra log entries on the server so it is always nice to clean those up.

Items we addressed include:

  • Fatal Errors : code will stop running
    • SLP_Power_Cron::$addon access level
      The Power add on visibility of the $addon variable was set to the lower-level private access when the base class it extended requires protected or higher visibility.

      Declaration added in 2023.10 per IDE recommendation that dynamically scoped variables are not longer allowed in PHP 8.2 with incorrect private $addon; property declaration on the class. The proper fix was to remove the phpDoc comment block hints that declared a hint for the property, indicating it was private to this class (phpDoc or IDE doc rules processing bug).
  • Warnings : code will run
    • version_compare() – null parameter not allowed
      Happens when a prior version was not installed (null) , which PHP 7 evaluated as “nothing” and version_compare() would return “this version is not newer”. It still does that but explicitly wants a value instead of null to compare against (we set the installed version to match the current version, which returns “this version is not newer”.

Store Locator Plus® Patches Search Form Name Label

Store Locator Plus® Release Notes
SaaS 2022.08.08 / WordPress 5.14

Store Locator Plus® has been updated for the early August 2022 release.   This impacts both the WordPress plugins and the SaaS product.     Users of the WordPress plugins will need to download and update to the latest releases.   SaaS users will see these updates automatically.

MySLP SaaS All Levels

A patch has been put into place on the JavaScript core method that reduces network I/O from REST API calls when rendering map labels.    The pre-patched version would consider various labels as not being set if a user was setting a label to an empty string.  This created a REST API call for every location that was being displayed to fetch new label information.  This patch reduces those calls to a single REST API request per page render versus per-location rendered.

MySLP SaaS Professional and Enterprise Updates

This release patches search form name labels and the name placeholder.   These settings were not being honored.  The functionality has been restored.

The map search form “Hide Address Entry” has been patched to hide ONLY the address input box, not the entire search form.

Version Info

The changes noted above can be found in the following update.

Store Locator Plus® (SaaS Edition) : 2022.08.08
Store Locator Plus® for WordPress: 5.14.X
Store Locator Plus® for WP : Experience: 5.14.X

WordPress Store Locator Plus Anniversary Sale

We are lowering the price of select add-ons to celebrate the WordPress Store Locator Plus 10 year anniversary !

Power Add-on

The Power add-on is now listed for sale at $150. This is a buy and own do it yourself add-on.

Popular features included with Power add-on

  • Import/Export your location data to csv file
  • Categorize , Tag locations
  • Reporting tools
  • Directories
  • SEO Pages
  • Location sensor

Experience Add-on

 

The Experience Add-on to our Word Press Store Locator Plus plug-in is on sale for $100! Thats a $100 savings.  This is an add-on to the Plug-in Version of Store Locator Plus

  • Change the Layout
  • Change the Look Of The Map
  • Add Location Search  buttons via Widgets
  • Add Discrete search filters by City, State more
  • Add Customize style sheets for search , map and results layouts.

Premier  Yearly Subscription

Our Premier sign up fee has been reduced as a promotional sale to celebrate the 10 year anniversary of the SLP plug-in.  Sign up fee is a low $49. The renewable annual Premier subscription remains at $275.  The total price for a limited time $324.  The Premier subscription includes both the Power and Experience add-ons as well as additional features in the layouts, search criteria, including (but not limited to)

Premier customers input for new features are always welcome.

See the Premier Description for additional information