I just noticed that all user names display in lower case, even though the actual user name contains capitals in WP, yet moderators and admins display correctly. Is this by design? Can it be changed?
SP 5 RC1
WP 3.3
All plugins up to date
All themes up to date, though I use the default theme and customize the overlay in my own theme.
where?? obviously not here… all our names retain case… so you may have another plugin enforcing that… a link to example would be helpful…
so, only for admins you get caps you say? have you really checked the display name of the user? not the login, but the display name?
what option have you selected for the display name? forum – profile – profile options?
if its display name, worth looking in the sfmembers table and see if caps in there or not… users can change their display name…
so, only for admins you get caps you say? have you really checked the display name of the user? not the login, but the display name?
Yes. Display names are all lower case. User names are normal. Changing between login and display name has no effect unless the Allow user to choose display name is unselected.
Interesting is that all the affected users were imported from PHPBB using the import tool.
Fixed by unselecting the option to allow users to choose and forcing WP login.
so just to be clear, you are saying when you imported names from phpbb, they all got set to lowercase regardless of what they were in phpBB?
Mr Papa said
so just to be clear, you are saying when you imported names from phpbb, they all got set to lowercase regardless of what they were in phpBB?
Yes, it appears that all imported users have lowercase display names (or in a drunken moment I changed hundreds).
The SP ‘display_name’ column is mapped to the phpBB ‘username’ column for importing. We run that data though the same filters used to check validity of input for any dislpay_name in the SP system and there is nothing there that forces lower-case.
Interesting.
SP importer is the only thing that touched that data – I have a plugin that adds registered users to a newsletter list, but all users added after the import are correct and all users with moderator (or above) displayed correctly.
Yellow Swordfish said
How was the ‘username’ column held in the phpBB database?
Can you be more specific? I still have the original DB, if that helps.
Well as I said above, the display name in SP is mapped during the import from the ‘username’ column in the phpBB users database table. So the question was how does the data look in that column? Is is all lower case for example?
OK, Username in the PHPBB DB is fine – however, the username_clean column is all lowercase. Is it possible that the import tool is using the username_clean column?
As an example…
Username, username_clean
‘Kineth’, ‘kineth’
‘Robin’, ‘robin’
no, not exactly…
the wp display_name is mapped from username
the wp user_login is mapped from username
the wp user_nicename is mapped from the username_clean
now I do see an error check that looks if the display_name is empty, then the user_nicename is mapped into the display_name… something in that empty check looks a bit fishy… so I will need to confer with Andy on that since he wrote the importer…
