Country random order in dropdown

More
1 week 3 days ago #166385 by Pete
Country random order in dropdown was created by Pete
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:
Code:
SET @i:=0; UPDATE #__osmembership_countries SET ordering=@i:=@i+1 WHERE 1 ORDER BY name;
(replace #_ with your db prefix)

Please Log in or Create an account to join the conversation.

More
1 week 2 days ago #166386 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Country random order in dropdown
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
The following user(s) said Thank You: Pete

Please Log in or Create an account to join the conversation.