|
Joined: Oct 2007
Posts: 361 Likes: 8
Enthusiast
|
Enthusiast
Joined: Oct 2007
Posts: 361 Likes: 8 |
We have a user on our board who cannot login. Even with me taking control of his account, changing the password (so I know what it is), logging out and then attempting to login, the login fails.
Here's the error message: Username/Password not found.
I thought at first that it might be related to his login name having spaces in it (xxx xx xxxxx), but we have other login names with similar patterns and spaces in the name, and they are not having this problem.
If I attempt to login using my login name and an incorrect password, I get this error message: Incorrect password for that username. If I do exactly the same thing with his account, I get the same error I wrote above when I type in the correct password.
Any idea what where to go to fix this would be appreciated.
|
|
|
|
Joined: Apr 2007
Posts: 120
member
|
member
Joined: Apr 2007
Posts: 120 |
Is it possible the username has a space at the end? Would UBB allow that to happen?
|
|
|
|
Joined: Oct 2007
Posts: 361 Likes: 8
Enthusiast
|
Enthusiast
Joined: Oct 2007
Posts: 361 Likes: 8 |
I think it's possible, but I tested for that and got the same result.
|
|
|
|
Joined: Jun 2006
Posts: 811
old hand
|
old hand
Joined: Jun 2006
Posts: 811 |
Sounds like something funky from the log-in name that is messing it up.
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
I would edit the user account using PHPMyAdmin and make sure everything is ok in the database, manually change the password and then try logging in again to his account to see if that fixes the problem.
This sounds like a corruption in he member file in the data base.
|
|
|
|
Joined: Oct 2007
Posts: 361 Likes: 8
Enthusiast
|
Enthusiast
Joined: Oct 2007
Posts: 361 Likes: 8 |
Sounds like something funky from the log-in name that is messing it up. That was my first thought, but, as I stated in the original post, we have other accounts with similar patterns that work fine. So, I doubt the problem is the login name. It's something unique to this account. I just don't know what it would be.
|
|
|
|
Joined: Oct 2007
Posts: 361 Likes: 8
Enthusiast
|
Enthusiast
Joined: Oct 2007
Posts: 361 Likes: 8 |
I would edit the user account using PHPMyAdmin and make sure everything is ok in the database, manually change the password and then try logging in again to his account to see if that fixes the problem.
This sounds like a corruption in he member file in the data base. Yes, but what to edit? And where would the corruption be? Is there a way to identify it? I don't need phpmyadmin (and don't have it installed) to edit the db, but I do need to have some idea of where to look. I assume the problem is going to be in the _USERS table. When I look at the columns in that table and compare his information, it all looks quite normal.
|
|
|
|
Joined: Oct 2007
Posts: 361 Likes: 8
Enthusiast
|
Enthusiast
Joined: Oct 2007
Posts: 361 Likes: 8 |
Here's something strange. When I run the following command, I get a return for my account but not for his.
select * from xxx_USERS where USER_LOGIN_NAME='mine'
select * from xxx_USERS where USER_LOGIN_NAME='his'
(I've munged the three letter prefix that I use and replaced the actual user login names with mine and his.)
That indicates that there is something wrong with his account but what?
|
|
|
|
Joined: Oct 2007
Posts: 361 Likes: 8
Enthusiast
|
Enthusiast
Joined: Oct 2007
Posts: 361 Likes: 8 |
I logged in to the db and ran some commands. I found the problem. His user login name is not "xxx xx xxxxx", it's " xxx xx xxxxx". IOW, there's a space before the first character. Sheesh.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
This is why I say we get the "admin" ability to edit usernames :/...
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
I agree there totally Gizmo.
|
|
|
|
Joined: Apr 2007
Posts: 120
member
|
member
Joined: Apr 2007
Posts: 120 |
I logged in to the db and ran some commands. I found the problem. His user login name is not "xxx xx xxxxx", it's " xxx xx xxxxx". IOW, there's a space before the first character. Sheesh. I think it would be worth the coding effort to not allow spaces before or after the login or password.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Yes to what Gizmo said, that's coming in the control panel update. And yes, to what Piper said is I need to edit the code so it doesn't allow spaces at the beginning/end even when special characters are turned on.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
I'm totally for "no space before and after" the pdn and username; but I do know several users who casually use spaces in their passwords (in fact, one of them is wheelchair bound and hardly has use of her hands and has to enter numerous spaces in her password)
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
|
|