Support » Plugin: Store Locator Plus for WordPress » Dropdown missing

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Store Locator Plus

    (@charlestonsw)

    Did you bring over your location data? The pulldown list is built from the locations in the database.

    Would I find this file in PHPMyAdmin or would this be something I could check on the FTP?

    Plugin Author Store Locator Plus

    (@charlestonsw)

    It is part of the WordPress database. Typically the wp_store_locator table. You need to export/import that table to move your locations with you.

    PhpMyAdmin can help you with this. There are plugins that will do a restore/backup as well.

    I imported all my database I thought. I tried to import just that table and received this error:

    Error

    SQL query:

    — — Database: gro1211007500053 — — ——————————————————– — — Table structure for table wp_store_locator — CREATE TABLE wp_store_locator ( sl_id mediumint(8) unsigned NOT NULL auto_increment, sl_store varchar(255) default NULL, sl_address varchar(255) default NULL, sl_address2 varchar(255) default NULL, sl_city varchar(255) default NULL, sl_state varchar(255) default NULL, sl_zip varchar(255) default NULL, sl_country varchar(255) default NULL, sl_latitude varchar(255) default NULL, sl_longitude varchar(255) default NULL, sl_tags mediumtext, sl_description text, sl_email varchar(255) default NULL, sl_url varchar(255) default NULL, sl_hours varchar(255) default NULL, sl_phone varchar(255) default NULL, sl_image varchar(255) default NULL, sl_private varchar(1) default NULL, sl_neat_title varchar(255) default NULL, sl_linked_postid int(11) default NULL, `sl_[…]

    MySQL said: Documentation
    #1050 – Table ‘wp_store_locator’ already exists

    Should I delete the store locator table and then import? What about recent information since the database transfer, will I lose the newly imported information? Is there a way to merge the tables so not to lose any current information? Thanks for any help.

    I’m also comparing my two databases and can’t seem to see a difference. I have all my addresses, cities, zips in the current database, the same as the old.

    Plugin Author Store Locator Plus

    (@charlestonsw)

    The table cannot exist. Edit the MySQL export file and remove the create database entry, only keep the inserts.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Dropdown missing’ is closed to new replies.