Title: Dropdown missing
Last modified: August 20, 2016

---

# Dropdown missing

 *  [BLIND2URIZ](https://wordpress.org/support/users/blind2uriz/)
 * (@blind2uriz)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/dropdown-missing/)
 * 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/](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](http://growingupinthevalley.com/store-locator.png)
 * Any thoughts? Thanks for any help.
 * Thanks,
    John
 * [http://wordpress.org/extend/plugins/store-locator-le/](http://wordpress.org/extend/plugins/store-locator-le/)

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [Lance Cleveland](https://wordpress.org/support/users/charlestonsw/)
 * (@charlestonsw)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/dropdown-missing/#post-3436244)
 * Did you bring over your location data? The pulldown list is built from the locations
   in the database.
 *  Thread Starter [BLIND2URIZ](https://wordpress.org/support/users/blind2uriz/)
 * (@blind2uriz)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/dropdown-missing/#post-3436251)
 * Would I find this file in PHPMyAdmin or would this be something I could check
   on the FTP?
 *  Plugin Author [Lance Cleveland](https://wordpress.org/support/users/charlestonsw/)
 * (@charlestonsw)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/dropdown-missing/#post-3436255)
 * 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.
 *  Thread Starter [BLIND2URIZ](https://wordpress.org/support/users/blind2uriz/)
 * (@blind2uriz)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/dropdown-missing/#post-3436257)
 * 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.
 *  Thread Starter [BLIND2URIZ](https://wordpress.org/support/users/blind2uriz/)
 * (@blind2uriz)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/dropdown-missing/#post-3436258)
 * 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 [Lance Cleveland](https://wordpress.org/support/users/charlestonsw/)
 * (@charlestonsw)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/dropdown-missing/#post-3436266)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/store-locator-le_dac7af.svg)
 * [Store Locator Plus®](https://wordpress.org/plugins/store-locator-le/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/store-locator-le/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/store-locator-le/)
 * [Active Topics](https://wordpress.org/support/plugin/store-locator-le/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/store-locator-le/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/store-locator-le/reviews/)

## Tags

 * [drop-down](https://wordpress.org/support/topic-tag/drop-down/)

 * 6 replies
 * 2 participants
 * Last reply from: [Lance Cleveland](https://wordpress.org/support/users/charlestonsw/)
 * Last activity: [13 years, 4 months ago](https://wordpress.org/support/topic/dropdown-missing/#post-3436266)
 * Status: not resolved