I now tried to add the states back, by adding state by state to Sweden. But for some reason the states also show up under the country "Other"???

Hello Torgrim Sandvoll,

Sorry for late reply to this,
I have tested in my locally, I can't reproduce this issues when i delete all the countries and leave 1 country then add 1 more called "Other" country, then the state will not show any state related on this country "Other".

Can you provide us with your Joomla backend and FTP access so we can help you check on this? Please advise.

See site login details below.

What I did was to first initialise, then delete all countries except 5. Then add one new country.

hello Torgrim Sandvoll,

I am really sorry for the delay of this reply as it is a weekend for us here.
May i have the permission to "initialise" all your current data to default countries/state data?

Because I have tried to create a new country called "OTHERS" and created a new state under this country, it seems like work fine for me.
Check my screenshot below.

Hi Arlex,

Thank you for your answer.
Ok, I see now that it is working in the frontend.

Think there must be a bug in the backend, because if I choose to View States for the new country "OTHER" all the states show up. For other countries only the states corresponding to that country shows up.

See me screencast here:
http://screencast.com/t/XzEnXfYO

I will just leave that as it is, as long as it is working in the frontend I (or more correct my members) are happy!

Nah, it is still not working...

I added a new country "Other" with State "NA". When viewing states for this country in backend all states show up.
But in frontend only "NA" shows up.

I then added new country "Sweden". With 20 states. All these states now shows up both in Sweden and Others... (both in frontend and backend).

This is messed up...

Could I please get access to the database files. I can enter the correct states for the nordic countries + add a "Other" country in your database. Then when I (and others) initialise, we just have to delete the countries we do not need. (The states for the nordics are wrong for most of the countries, either with wrong characters (non-nordic) or as for Denmark it should just be 5 regions/states).

Giving up... 3 hours with entering the correct names for states for all the nordic countries, and EasySocial messed it up in the end.

PS: For some reason Sweden alse got the "NA" state from "Others" country. The two state lists for my two new countries merged for some reason.

Hello Torgrim Sandvoll ,

I am really sorry for the delay of this reply as it is a weekend for us here.
Thanks for take your time to described and tested this functionality, now I can reproduce this issues from my locally, I will get back to us as soon as possible.

Am i right is there got 2 issues?
#1. when you add the new country and state that moment and click on "view state", then it will not show correctly data.
#2. when you select the country from registration page, then it will not show correctly of the state from the new added state.

All the region data is stored in this table -> #_social_regions

Yes, you are correct.

#1 If I add a new country in the backend. When you click "View states" in the backend for that country, it will not show correct (empty) list, but all states for other countries also.

#2 If I add state to the new country it will show correctly in the frontend (allthough in the backend it shows many states, in the frontend it only shows the new state). But if you add another new country (2 new countries) the new states you add in the backend for these two countries, wil merge and show up for both in the backend and frontend.

#3 If you delete a country, it seems like its states are not deleted in the backend (they somehow show up for any new countries you might add).

PS: I can help add the correct states to your installation/initalising database for the nordic countries. Today there are many errors and bad handling of states with nordic characters like æ, ø and å.

I have no table named *_social_regions in my Joomla database? (Using PHPMyAdmin).

Hi,

I've applied a patch on your site in regards to this bug. The bug is where, there is a mismatch in between country and state for new data.

Thanks Jason!
I moved the states belonging to Sweden from Other to Sweden. Then deleted three states from Other that did not belong to any of my remaining countries (somehow they was not deleted when deleting all the other countries).

Everything seems to work now, both in frontend and backend.

PS: I also tested adding a new "TestState" state to Sweden. Is only showed up for Sweden, and not for Other too. Works!

Great! This fix will be included in the next version.