Previous Thread
Next Thread
Print Thread
Hop To
Changing User Name #257425 10/23/2015 5:14 AM
Joined: Mar 2007
Posts: 522
SteveS Offline OP
Addict
OP Offline
Addict
Joined: Mar 2007
Posts: 522
I have an old member who hasn't been able to log in since August. I haven't changed anything, but he thinks it might be because he has a special character in his login name. Can I change that (in the tables, I guess) without breaking it? Or should we be looking at something else?


Steve

UBB.classic from 2000-2003
UBB.threads from 2003-present!
Re: Changing User Name [Re: SteveS] #257426 10/23/2015 7:56 AM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
It has been a long time since I have done that. So I don't recall what impact it had other than possibly he will need to wipe his cookies.
Anyway I would just look and see if there are indeed special characters.
That could be in member management or even become the member and see if you have any issues.
Of course if you do that you will need to ask him if it is okay.

Then I would just add a new account manually give him the login to see if he can in fact login for a test.

You never did say what was the issue with the login.
Like no error or invalid login error.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Changing User Name [Re: SteveS] #257427 10/23/2015 8:08 AM
Joined: Mar 2007
Posts: 522
SteveS Offline OP
Addict
OP Offline
Addict
Joined: Mar 2007
Posts: 522
He has always had a special character... the copyright symbol.

And you are correct; I did not ask him what error message he was getting.

I looked at my logs since the last time he logged in, and I have not changed any settings. He has been an active member since my Classic days, which ended probably in 2003.


Steve

UBB.classic from 2000-2003
UBB.threads from 2003-present!
Re: Changing User Name [Re: SteveS] #257428 10/23/2015 8:15 AM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994
well then it could be just a matter of another login issue.
I can say that I upgraded to win10 64 on 3 of 4 pc's at home and I can't login at all at this site with the new EDGE browser.
It just accepts my login and returns to the summary page showing that I am not logged in.
No errors what so ever.
I even turned off virus protection and the firewall and I lowered the security setting in the browser. no go.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Changing User Name [Re: SteveS] #257431 10/23/2015 10:53 AM
Joined: Dec 2003
Posts: 5,994
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,994


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Changing User Name [Re: SteveS] #257432 10/23/2015 11:45 AM
Joined: Mar 2007
Posts: 522
SteveS Offline OP
Addict
OP Offline
Addict
Joined: Mar 2007
Posts: 522
Just heard back... he is getting "username not found," and it is multiple platforms and multiple systems.

It is one of my sponsors, so it is kind of critical.


Steve

UBB.classic from 2000-2003
UBB.threads from 2003-present!
Re: Changing User Name [Re: SteveS] #257433 10/23/2015 11:51 AM
Joined: Apr 2004
Posts: 1,538
isaac Online Splat
UBB.threads Developer
Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,538
when he is at the login screen, instead of entering his username where it asks for a username, have him login with his email address in that box.

you can login with either your username or email address, even though the prompt is only asking for username.


ignore this comment, as it is incorrect for the version you currently have installed.

I will be posting a sql solution in my reply below...

Last edited by id242; 10/23/2015 12:39 PM.

Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Changing User Name [Re: SteveS] #257434 10/23/2015 12:51 PM
Joined: Mar 2007
Posts: 522
SteveS Offline OP
Addict
OP Offline
Addict
Joined: Mar 2007
Posts: 522
Thank you, Isaac!


Steve

UBB.classic from 2000-2003
UBB.threads from 2003-present!
Re: Changing User Name [Re: SteveS] #257435 10/23/2015 12:51 PM
Joined: Mar 2007
Posts: 522
SteveS Offline OP
Addict
OP Offline
Addict
Joined: Mar 2007
Posts: 522
Thank you, Isaac!


Steve

UBB.classic from 2000-2003
UBB.threads from 2003-present!
Re: Changing User Name [Re: SteveS] #257436 10/23/2015 12:57 PM
Joined: Apr 2004
Posts: 1,538
isaac Online Splat
UBB.threads Developer
Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,538
1) Go to "Control Pannel"
2) Under the "Tools & Info" section at the bottom, go to the "Database Tools" page
3) Select the "SQL Command" tab
4) Copy/paste the sql command from below, with the correct changes, then click the "Execute" button to perform the action.

DOUBLE-CHECK THAT THE USER NUMBER IS CORRECT FOR THE USER YOU WANT TO GIVE THE NEW LOGIN NAME TO.

UPDATE ubbt_USERS
SET USER_LOGIN_NAME = 'newloginname'
WHERE USER_ID = 'usernumber'


newloginname = the new user name you want to update the user with
usernumber = the user's current member number. you can find this by viewing the number shown in the url of their user profile, and within that page.

---

example:
UPDATE ubbt_USERS
SET USER_LOGIN_NAME = 'SuperSteve'
WHERE USER_ID = '3372'

This SQL command would update your login name on UBBCentral.com to "SuperSteve" since your user number here is 3372.


Last edited by id242; 10/23/2015 1:05 PM. Reason: clarity :)

Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Changing User Name [Re: SteveS] #257437 10/23/2015 1:17 PM
Joined: Mar 2007
Posts: 522
SteveS Offline OP
Addict
OP Offline
Addict
Joined: Mar 2007
Posts: 522
Thank you... I will run it when I get home from work tonight.


Steve

UBB.classic from 2000-2003
UBB.threads from 2003-present!
Re: Changing User Name [Re: SteveS] #257448 10/26/2015 4:24 AM
Joined: Mar 2007
Posts: 522
SteveS Offline OP
Addict
OP Offline
Addict
Joined: Mar 2007
Posts: 522
My "customer" finally tried it during the night, and he was able to log in successfully.

Thanks again.


Steve

UBB.classic from 2000-2003
UBB.threads from 2003-present!

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Exceeded Number of attachments
by rbrtgrmn - 11/02/2019 9:57 PM
Forum New User Registration
by kf6zpl - 10/25/2019 10:45 AM
Having issue with redirects to UBB classic URLs
by amciotola - 10/16/2019 12:11 AM
Who's Online Now
2 registered members (isaac, JAISP), 44 guests, and 347 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)