Previous Thread
Next Thread
Print Thread
Hop To
Changing User Name
#257425 10/23/2015 6: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
SteveS #257426 10/23/2015 8:56 AM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Online Yawn
Joined: Dec 2003
Posts: 6,144
Likes: 21
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
SteveS #257427 10/23/2015 9: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
SteveS #257428 10/23/2015 9:15 AM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Online Yawn
Joined: Dec 2003
Posts: 6,144
Likes: 21
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
SteveS #257431 10/23/2015 11:53 AM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Online Yawn
Joined: Dec 2003
Posts: 6,144
Likes: 21


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Changing User Name
SteveS #257432 10/23/2015 12:45 PM
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
SteveS #257433 10/23/2015 12:51 PM
Joined: Apr 2004
Posts: 1,697
Likes: 49
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,697
Likes: 49
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 1:39 PM.

Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Changing User Name
SteveS #257434 10/23/2015 1: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
SteveS #257435 10/23/2015 1: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
SteveS #257436 10/23/2015 1:57 PM
Joined: Apr 2004
Posts: 1,697
Likes: 49
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,697
Likes: 49
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 2:05 PM. Reason: clarity :)

Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Changing User Name
SteveS #257437 10/23/2015 2: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
SteveS #257448 10/26/2015 5: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!

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Report Post bug..
by Morgan - 07/05/2020 1:48 PM
Trial Subscription question.
by Ruben - 07/03/2020 2:34 PM
Unread posts no longer tracked per user...
by KirkW - 06/16/2020 12:21 AM
Max Image file size upload
by jjjjj - 06/10/2020 10:25 PM
Error on Inert into POSTS
by jjjjj - 06/07/2020 8:09 PM
Who's Online Now
3 members (Morgan, infernus86, JAISP), 95 guests, and 32 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
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