Support

Home Forums Event Espresso Premium Dropdown population error

Dropdown population error

Posted: February 19, 2019 at 5:54 pm


mwjuker

February 19, 2019 at 5:54 pm

When you hit the drop down box for the states, there are not only states but people’s names. Then when you go down further in the registration form and hit the “red” line which says “click here to add a new state/province”, the drop down box lists countries and people’s names. If you get further into the registration process and get to the payment section, you get the same problem where it asks you to complete your address with your whole address and state/country.

https://www.cincinnatisportsmed.com/wp-content/uploads/2019/02/Screen-Shot-2019-02-19-at-7.52.28-PM.png


Tony

  • Support Staff

February 20, 2019 at 4:12 am

Hi there,

Generally, when we see this it means you’ve migrated from EE3 but when you used EE3 previously someone repurposed the address fields so the values in EE3 had names.

To fix this you’ll need to disable those values within:

Event Espresso -> General Settings -> Countries.

For example, if there’s a country that is a name, select that name in the dropdown on the above and set the ‘Country Appears in Dropdown Select Lists’ to no, then save. Repeat for each country.

For ‘states’ you’ll need to select the Country and wait for the states to load, each state has an option to display in the dropdowns, change those to no and save again


mwjuker

February 20, 2019 at 7:00 pm

Ok, there are literally hundreds. Is there no way to mass delete them?
Thank you


mwjuker

February 20, 2019 at 7:06 pm

Would it help if I update to the latest EE4? I haven’t done that yet.


Tony

  • Support Staff

February 21, 2019 at 5:09 am

Ok, there are literally hundreds. Is there no way to mass delete them?

No.

The problem is EE would have no way to know what country/state is a real country/state so how would it know what to delete?

Not only that but if you delete them from the database rather than mark them inactive, every single registration that has a relationship to any of those countries will not throw a fatal error when it tries to load a value that no longer exists.

The other option is to not migrate over your EE3 data and start fresh with EE4.

Would it help if I update to the latest EE4? I haven’t done that yet.

No, (although you should update anyway) those values have been saved to the database during the EE3 -> EE4 migration, updating EE will not change those.


mwjuker

February 21, 2019 at 7:46 am

Ok, they still show up in the dropdown when asked to add a state or province. Can I delete the option to add your own state or province?

https://www.cincinnatisportsmed.com/wp-content/uploads/2019/02/Screen-Shot-2019-02-21-at-9.45.16-AM.png

https://www.cincinnatisportsmed.com/wp-content/uploads/2019/02/Screen-Shot-2019-02-21-at-9.45.50-AM.png


Tony

  • Support Staff

February 21, 2019 at 8:12 am

Yes you can using this snippet:

https://gist.github.com/joshfeck/7bf112ee2dc9e49f7e3f14b8c2b59611

You can add that to a custom functions plugin on your site, we have some documentation on creating one here:

https://eventespresso.com/wiki/create-site-specific-plugin-wordpress-site/


mwjuker

February 21, 2019 at 7:39 pm

Thank you. That worked. Last question. EE runs very slow on our site on both front and back end. Did we do something wrong on installation or is that normal?


Tony

  • Support Staff

February 22, 2019 at 4:36 am

It’s not normal but its highly dependent on your server.

Can you define slow, please?

What type of hosting are you using?


mwjuker

February 22, 2019 at 6:44 am

Absolutely. When you register for an event it takes several seconds for you to actually get into the cart. And then several seconds to get to payment…etc. On the back end it takes several seconds to makes changes and save anything. Sometime even selecting an option takes forever. By several I mean at a minimum of 10 seconds. Probably closer to 15.


Tony

  • Support Staff

February 22, 2019 at 6:58 am

Yeah, that’s fairly long and usually means you need a better server/hosting package. (Not always, but it’s usually because your on a shared hosting package that you’ve outgrown).

What type of hosting are you using?

Which version of PHP are you using? (You can find it in Event Espresso -> Maintenance -> System information)

The support post ‘Dropdown population error’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso