About 2 years back, I pointed out a Collation problem concerning non-latin letters (å, ø, æ etc) in Usernames.
This was corrected shortly after.
It seems this has cropped up again.
Not sure when, as it is not often people use such letters in their Usernames, but someone made me observant of this earlier today.
If not, and it is isolated to me, anyway of pointing me in the right direction?
(I have tried searching for similar issues here, but that's not panning out).
Ensure all your database tables and columns have the correct collations. Register a user directly through Joomla from backend using a username with characters that normally mess up with CB and see if it works. If it does repeat the test using CB > User Management. If it does mess up then it's a Joomla user store issue or database issue.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
If the same issue happens with just Joomla, completely bypassing CB, then the issue is in Joomla or is in your database. You should check the _users table as that's where Username is stored (CB doesn't store the username anywhere).
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Here is the jos_users table.
It seems to be correct as far as I can see...?
And yes, when I create a profile JUST from the Users in Joomla, the same issue persists.
Which (as you say) indicates the issues stems from Joomla, not CB.
Click the "Operations" tab when viewing the _users table and ensure the entire table has the correct collation as well. Now click to view your entire database and not any 1 particular table then click "Operations" and check the collation for the entire database table. Aside from that I don't know what more to advise as the issue appears to be coming from Joomla it self.
Joomla 1.5.26
This could perhaps be the cause. Maybe is fixed in J2.5/J3.0? Have you tried a J2.5 or J3.0 install to see if same issue is present there?
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
