- Posts: 6
- Thank you received: 0
Country random order in dropdown
- Pete
- Topic Author
- Offline
- New Member
Less
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:
(replace #_ with your db prefix)
Code:
SET @i:=0;
UPDATE #__osmembership_countries SET ordering=@i:=@i+1 WHERE 1 ORDER BY name;
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
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
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.
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.