WordPress.org

Ready to get started?Download WordPress

Forums

Store Locator Plus
Dropdown missing (7 posts)

  1. BLIND2URIZ
    Member
    Posted 1 year ago #

    I'm using version 3.8...

    I recently changed hosts and now my drop down is missing w/ all the cities that I've entered. There used to be a drop down showing the several cities that I had listings in so that I could choose just those cities. But now It's gone. Here's a link to the page...

    http://growingupinthevalley.com/store-locator/

    Here's a link to a screen cap of where it used to be...

    http://growingupinthevalley.com/store-locator.png

    Any thoughts? Thanks for any help.

    Thanks,
    John

    http://wordpress.org/extend/plugins/store-locator-le/

  2. Charleston Software Associates
    Member
    Plugin Author

    Posted 1 year ago #

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

  3. BLIND2URIZ
    Member
    Posted 1 year ago #

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

  4. Charleston Software Associates
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  5. BLIND2URIZ
    Member
    Posted 1 year ago #

    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.

  6. BLIND2URIZ
    Member
    Posted 1 year ago #

    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.

  7. Charleston Software Associates
    Member
    Plugin Author

    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags