username/display name issue

Started by CitrusSponge, October 29, 2014, 09:18:02 PM

Previous topic - Next topic

CitrusSponge

I'm trying to help a member get a username+display name of 'Doge', but every time I try, I get the following error:
The following errors occurred when trying to save your profile:
The selected username/display name has already been taken.

I have searched my entire forum, and memberlist for anyone who has Doge as their display name/username, and there's no one, so why isn't it available?

Help?

Sir Osis of Liver

Look in smf_members in your database and see if the name is in there.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

JBlaze

If you allow members to change their display names, there's a chance that someone had registered with the username 'Doge', and later changed their display name to something else. This means that the username 'Doge' is already taken, as usernames and display names are stored separately.
Jason Clemons
Former Team Member 2009 - 2012

Arantor

I would also question which memberlist was checked, since there's the normal one (which wouldn't show this) and the admin one (which would)

CitrusSponge

Quote from: Arantor on October 30, 2014, 12:15:56 AM
I would also question which memberlist was checked, since there's the normal one (which wouldn't show this) and the admin one (which would)
I checked them both, no results.

Arantor

What about the Admin > Members > Registration > Reserved Names list?

CitrusSponge

Quote from: Arantor on October 30, 2014, 11:08:00 AM
What about the Admin > Members > Registration > Reserved Names list?
Nope it's not on there.

Arantor

OK, so let's try something else. In phpMyAdmin, SQL area:

SELECT id_member, real_name, member_name
FROM smf_members
WHERE real_name LIKE '%doge%' OR member_name LIKE '%doge%'

CitrusSponge

Quote from: Arantor on October 30, 2014, 11:16:35 AM
OK, so let's try something else. In phpMyAdmin, SQL area:

SELECT id_member, real_name, member_name
FROM smf_members
WHERE real_name LIKE '%doge%' OR member_name LIKE '%doge%'


''MySQL returned an empty result set (i.e. zero rows). (Query took 0.0025 sec)''

Arantor

Very interesting and strange.

So, what mods are installed?

CitrusSponge


CitrusSponge


Shambles

Have you checked your banned members list?

Arantor

We checked that with the above query. I don't have any ideas at this point :(

Sir Osis of Liver

IIRC, phpmyadmin allows you to search the entire database for a string.  Have you tried that?
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Arantor

It does, but what exactly would be the point?

There should be only two places where SMF should be checking, the real_name and the member_name, and we have established it is neither of those.

Which makes me wonder if there is something askew in the code, but none of the mods seem relevant either. So I guess we'll just have to look at Profile-Modify.php and Subs-Members.php.

Pipke

You have a Groupname that is called Doge? Does this affect the member maybe?
"If something is wrong, fix it if you can. But train yourself not to worry: Worry never fixes anything."

Click here to view my mods for SMF

Hey 👋 Did i helped... you like what i do. You can now buy me a coffee! ☕

Illori

nope that does not effect it at all. group names are separate from user names.

Advertisement: