Support

    You are here:  
  1. Home
  2. Support
  3. tabs menu editing
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (10)

Resolved User list is not in alphabetical order.

  1. dimazik
    dimazik
  2. Support
  3. Monday, May 08 2017, 05:30 PM
Good day, Admins.
Thank so much for your work!

There is one question. Where can I customize the alphabet of user lists?
I'm using Ukrainian. The letter "a" of course should be the first.
The list is sorted alphabetically, except for two letters of the Ukrainian alphabet.


Joomla 3.7.0; Easy Profile Pro 2.4.1; PHP7
Attachments (1)
b1.jpg b1.jpg
Responses (10)
admin
admin Accepted Answer
Admin
Hi,
Where can I customize the alphabet of user lists?

you can set the ordering column from User List menu item options (see screenshot).

I'm using Ukrainian. The letter "a" of course should be the first.
The list is sorted alphabetically, except for two letters of the Ukrainian alphabet.

If you have already selected the correct column then probably there is a problem with names,
for example:
"I" (latin) is different from "Ι" (cirillic), so mysql seems to use a bad order.

You can see the difference with a simple php urlencode function (see screeshot)
I (latin) => I
Ι (cirillic) => %CE%99
Attachments (2)
Schermata 2017-05-08 alle 18.35.48.png Schermata 2017-05-08 alle 18.35.48.png
Schermata 2017-05-08 alle 18.48.27.png Schermata 2017-05-08 alle 18.48.27.png
  1. more than a month ago
  2. Support
  3. # 1
dimazik
dimazik Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, it swas too late for us and our offices was closed :D

Ok, but what do I do now with urlencode function?)
Nothing, this is only an example to understand the difference between "I" (latin) and "Ι" (cirillic).

Mysql "Order by" statement order with this criteria:

A (latin)
B (latin)
.....
I (latin)
....
Z (latin)
A (cyrillic)
.....
I (cyrillic)
.....

So I think that names like "Iгнатенко" used I (initial) with latin charset

You should correct "I" (latin) with "I" (cyrillic) in these name.
  1. more than a month ago
  2. Support
  3. # 3
dimazik
dimazik Accepted Answer
This screenshot shows that before the letter "A" there are cyrillic "I" and "Є".
Of course, "Є" is absent in the latin.
I checked: the letter "i" is а сyrillic.
Maybe Joomla is to blame?This screenshot shows that before the letter "A" there are cyrillic "I" and "Є".\
Of course, "Є" is absent in the latin.
I checked: the letter "i" is сyrillic.
Maybe Joomla is to blame?
Thanks!
  1. more than a month ago
  2. Support
  3. # 4
admin
admin Accepted Answer
Admin
Hi,
we have not experience with Cyrillic charset, my statements are just suppositions.

for example (just another supposition):
Є is not a common Cyrillic char (it is used only in only in Ukrainian alphabet) and maybe your Mysql Server assume this as Symbol (Greek Epsilon) (not letter)

Can you please send me a link to see this list to investigate?

Maybe Joomla is to blame?
This is not a Joomla issue, this is something that regards Database server. Joomla and Easy Profile use a simple SQL "Order By" command, but the order is provided by Database.
  1. more than a month ago
  2. Support
  3. # 5
Rolandcharcker
Rolandcharcker Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 6
dimazik
dimazik Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 7
admin
admin Accepted Answer
Admin
Hi Dmitry,
and thanks for your availability, we have found the problem and will try to fix it for the next release. In the meantime you can set order by "Formatname".

About the problem:
Joomla have changed DB charset of #__users table, so when it is join with Easy Profile user table then the "order by" statement inherit directive COLLATE from #__users (so utf8mb4_unicode_ci instead utf8_unicode_ci)
  1. more than a month ago
  2. Support
  3. # 8
dimazik
dimazik Accepted Answer
Many thanks!
I'll wait for the update.
I will report the results.
  1. more than a month ago
  2. Support
  3. # 9
dimazik
dimazik Accepted Answer
It is excellent!
With the update of the component, the Kirilist alphabet (Ukrainian) is displayed correctly.
Thanks for the work!
  1. more than a month ago
  2. Support
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Request Support

Support is currently Online
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.