Country random order in dropdown

Hi, not sure if I did something wrong but this happened on two sites where I use Membership Pro. The country dropdown list was randomized and not in alphabetical order. I traced it down to the ordering column in #__osmembership_countries table. The value was zero for all entries. This is the query I used to fix it, maybe somebody has the same issue:
(replace #_ with your db prefix)

Thanks Pete. We added this ordering column to allow changing ordering of countries. The ordering set to name by default when you update from version of Membership Pro to new version.

But I forgot to handle it for new installation. Will address it in next release

Regards,

Tuan

I'm confused. I have the latest version of Membership Pro. My default state/country fields work perfectly. I added business state and business country and these are not behaving like the default state/country fields. I even made a copy of the originals and modified them.

My business_country list appears to be randomized as OP mentioned above. Meanwhile my business_state is blank despite the country selected.

How do I set my default country for business_country and my business state to be populated by the default country (U.S.)?

My configuration's default country is set to United States.

Hi Sue

As of right now, we can only have one country/state combination on the form. It is not possible two have second country/state field which select country show states of that selected country in the state field

I will see if I can support that behavior in future releases of the extension

Regards,

Tuan