Reply To: Add and import doesn't work after deleting wp_store_locator table

Home Forums Store Locator Plus Add and import doesn't work after deleting wp_store_locator table Reply To: Add and import doesn't work after deleting wp_store_locator table

#32316

Rachael
Participant

I solved this problem. This is how I did it.

First of all, I realize that the Store Locator Plus Janitor 4.0.01 is supposed to take care of some of the housekeeping I had to do, but the plugin just did not work on our system. There is no console, control, panel, button, just no way of accessing the Janitor fucntions.

But I realized of the dozen things I tried to fix the problem of SLP not being able to create a db table, or after I manually created the table, and even when I managed to get SLP to insert new records, either through add or import, the location manager would still not display the locations for editing, with the resulting message of “No locations have been created yet.” – the last thing I thought of was that there must be remnants of previous installs in the database.

In the Janitor product page description I read that it cleaned out entries in the wp_options table. So, I wrote a couple of queries that searched for slp related entries in the wp_options table:

SELECT * FROM wp_options WHERE (option_name LIKE ‘sl_%’)

SELECT * FROM wp_options WHERE (option_name LIKE ‘%slp%’)

SELECT * FROM wp_options WHERE (option_name LIKE ‘slplus%’)

SELECT * FROM wp_options WHERE (option_value LIKE ‘slplus%’)

etc., and I found these records:

Array
(
    [option_id] => 852931
    [option_name] => slp-import-messages
    [option_value] => a:4162:{i:0;s:11:"1 :   added";i:1;s:11:"2 :   added";i:2;s:11:"3 :   a
Array
(
    [option_id] => 752
    [option_name] => slurp_page_installed
    [option_value] => 1
    [autoload] => yes
)
Array
(
    [option_id] => 852916
    [option_name] => sl_google_map_country
    [option_value] => United States
    [autoload] => yes
)
Array
(
    [option_id] => 855459
    [option_name] => sl_instruction_message
    [option_value] => Enter an address or zip code and click the find locations button.
    [autoload] => yes
)
Array
(
    [option_id] => 852915
    [option_name] => sl_location_table_view
    [option_value] => Normal
    [autoload] => yes
)
Array
(
    [option_id] => 855458
    [option_name] => sl_map_radii
    [option_value] => 10,25,50,100,(200),500
    [autoload] => yes
)
Array
(
    [option_id] => 855461
    [option_name] => sl_radius_label
    [option_value] => Within
    [autoload] => yes
)
Array
(
    [option_id] => 855462
    [option_name] => sl_search_label
    [option_value] => Address / Zip
    [autoload] => yes
)
Array
(
    [option_id] => 852913
    [option_name] => sl_use_name_search
    [option_value] => 0
    [autoload] => yes
)
Array
(
    [option_id] => 855463
    [option_name] => sl_website_label
    [option_value] => Website
    [autoload] => yes
)
Array
(
    [option_id] => 855460
    [option_name] => sl_zoom_level
    [option_value] => 4
    [autoload] => yes
)
Array
(
    [option_id] => 852914
    [option_name] => sl_zoom_tweak
    [option_value] => 1
    [autoload] => yes
)

There were also records with option_name values starting with a <code class=”plain plain”>csl-slplus- prefix.
I nuked all of these from the database (except for the one named ‘slurp’ — had to visually inspect each record to make sure it didn’t belong to some other plugin).

I killed the wp_store_locator table.

I deactivated and all plugins, including the main Store Locator Plus plugin.

I re-installed using store-locator-le.4.2.67.zip

The first record I added manually, and it displayed in the location manager (meaning SLP auto-created the wp_store_locator table).

I installed the SLP Pro module.

I used the import function to import the entire CSV, which promptly inserted, and then displayed all the new store records.

This problem solved. By the way, the SLP Janitor still doesn’t do anything on our site, even after all else seems tto have returned to normal.

  • This reply was modified 2 years ago by  Rachael.
  • This reply was modified 1 year, 7 months ago by  Cici. Reason: overload data