Support

Home Forums Event Espresso Premium Cannot see UK in Countries Drop Down

Cannot see UK in Countries Drop Down

Posted: July 29, 2020 at 6:58 am


facial_acupuncture

July 29, 2020 at 6:58 am

My main country is the US but I have people from the UK wanting to register for a virtual event. My plugin is up-to-date, but I cannot see “United Kingdom” in my countries drop down. I am most certain it was there before. Has something changed in the last release?

I do have a “GB” in my countries list, but I believe it was dynamically added by users, since it only contains three counties. I would prefer not to have to enter all of the UK information manually. Is there a way to add the entire UK in bulk?


Tony

  • Support Staff

August 3, 2020 at 9:52 am

Hi there,

Has something changed in the last release?

No, we haven’t changed how the countries system works in a long time.

Which version were you using prior to 4.10.6.p (the latest at the time of this reply)?

Do you have access to the database and are you comfortable viewing the tables?

If using phpMyAdmin can you open up {db_prefix}esp_country and click search, then input ‘GB’ into the CNT_ISO field and click go:

https://monosnap.com/file/TNaK8rr2UFmlFwgNuvrc2VPYVaMSbM

Do you see the UK returned, like this:

https://monosnap.com/file/xymv2Wzqicqy5Z6TpFLMkC5HvnLleh

Or if you prefer, click the ‘Export’ table for that table and select Quick export then Go. Send me the file that downloads and I’ll check that.

I’m just trying to confirm if the UK country is still in the database or not, if not I can give you a script that can add it in for you.


facial_acupuncture

August 27, 2020 at 11:53 am

Hi there, sorry for taking so long to get back to this. I am not entirely sure which version of EE was installed prior to the update.

I did find GB in the database but it seems to be incomplete. The Country Name is missing along with CNT_ISO3 and under CNT_Active the value was 0.

I made it active and also added United Kingdom to the country name and now it is showing up for me in my lists. So I think my problem is solved.

However, there are only 4 states/provinces for GB in my database or on the Countries settings page…I think they were added by users. Should all the counties be in there automatically? Not a big deal, I can add them later.

Thanks for your help


Tony

  • Support Staff

September 1, 2020 at 4:09 am

I am not entirely sure which version of EE was installed prior to the update.

You can check your activation history in:

Event Espresso -> Maintenance -> System information -> ee_activation_history

I did find GB in the database but it seems to be incomplete. The Country Name is missing along with CNT_ISO3 and under CNT_Active the value was 0.

Hmm, yeah that’s strange, I’m not sure what’s happened there.

So, the counties (states within EE itself) will only automatically download if there are none saved in the database already for that country. Problem is that removing what you have now may break and registrations linked to the counties you remove.

EE will generally avoid throwing fatal errors when something is missing from the DB but it’s still possible it may happen. I’ve tested removing a state assigned to a registration and went through various pages that pulled the value to check it worked (which it did and just shows ‘Please select’ for state) but its by no means extensive testing.

So you ‘could’ remove the states assigned to GB in the esp_state table (search by CNT_ISO) and then remove them. (Make sure you create a database backup before doing so).

Then if you select UK in general settings EE will download the ‘states’ for you but again, not that any registrations that used those states you removed will now have their address ‘broken’.

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: publish

Updated by  Tony 1 month, 3 weeks ago ago

Topic Tags

Tagged: 

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!
[gravityform id=80 title=false description=false ajax=false]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_80' ><form method='post' enctype='multipart/form-data' id='gform_80' action='/topic/cannot-see-uk-in-countries-drop-down/'> <div class='gform_body'><ul id='gform_fields_80' class='gform_fields top_label form_sublabel_below description_below'><li id='field_80_1' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_1' >First name<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_1' id='input_80_1' type='text' value='' class='medium' aria-required="true" aria-invalid="false" /></div></li><li id='field_80_2' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_2' >Email address<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_80_2' type='email' value='' class='medium' aria-required="true" aria-invalid="false" /> </div></li><li id='field_80_3' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' >GDPR Agreement<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_checkbox'><ul class='gfield_checkbox' id='input_80_3'><li class='gchoice_80_3_1'> <input name='input_3.1' type='checkbox' value='I consent to have this website store my submitted information so they can respond to my inquiry.' id='choice_80_3_1' /> <label for='choice_80_3_1' id='label_80_3_1'>I consent to have this website store my submitted information so they can respond to my inquiry.</label> </li></ul></div></li><li id='field_80_4' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_4' >Email</label><div class='ginput_container'><input name='input_4' id='input_80_4' type='text' value='' autocomplete='off'/></div><div class='gfield_description' id='gfield_description_80_4'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type='submit' id='gform_submit_button_80' class='gform_button button' value='Download Now' onclick='if(window["gf_submitting_80"]){return false;} if( !jQuery("#gform_80")[0].checkValidity || jQuery("#gform_80")[0].checkValidity()){window["gf_submitting_80"]=true;} ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_80"]){return false;} if( !jQuery("#gform_80")[0].checkValidity || jQuery("#gform_80")[0].checkValidity()){window["gf_submitting_80"]=true;} jQuery("#gform_80").trigger("submit",[true]); }' /> <input type='hidden' class='gform_hidden' name='is_submit_80' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='80' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_80' value='WyJbXSIsIjBiNjdjZjkyMDUzOWUxOWY5Y2NiZjIwMzM4YjA1Mjk4Il0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_80' id='gform_target_page_number_80' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_80' id='gform_source_page_number_80' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 80) {} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [80, 1]) } ); </script>
[i]
[i]