Error After Username Change

[KGodel]

Hello everyone! I'm back!

I run an online clan/gaming community, and up until recently all members were required to have a tag "[zG]" in front of their names. After some changes, we were able to add that automatically (making it significantly easier to use the Member List feature).

I ran a server query to remove the [zG] tags from all usernames in the database (I tested first, it worked as intended). Most of my members are having no issues, but some of them are getting "incorrect password" messages or "account does not exist" when using the new username. On top of that, many users (new and old) are not receiving emails sent by the site, which is a new phenomenon.

Does anyone have any idea what caused this? I have tried manually changing password and the error persists. I have had them clear their cache and cleared the site cache.

Any help is appreciated!

[Lynne]

What was the exact query(/ies) that you ran to change the username? You realize the username is not ONLY in the user table - it is in several tables. If you only changed it in the user table, then that isn't enough.

[KGodel]

I just ran the "update usernames" from the admin panel. Hopefully that should update them elsewhere? I only ran the query on the user table.

I ran:

UPDATE prefix_user SET username = SUBSTRING(username, 4) WHERE username LIKE '[zG]%'

[KGodel]

Bump. I updated usernames on every table I could find (I ran a search for the [zG] tag on each table to update) so I think I covered my bases (I also rebuilt thread information and such).

Most people do not have an issue, but there are still recuring issues where people cannot login or they get an "account does not exist" or "invalid password" error. I have cleared the cache and changed the cookie settings to that their old account info will not be interacting as much, but without a direct cause I am having trouble troubleshooting for them. Any help would be appreciated.

[ForceHSS]

Do you have a error log

[KGodel]

No, that's just it, it isn't giving them and error, it just says the account doesn't exist. If I had an error I could pinpoint the issue, but unfortunately I do not.

[ForceHSS]

How many accounts are messed up

[KGodel]

There is no way to know. It seems random. A majority of members do not have the issue, but the issue did not start until after I made the username changes.

[ForceHSS]

If you have a backup from not to far back you could restore it

[CAG CheechDogg]

I had this happen to me on my clan's website and it ended up being an extra space either before the username or at the end which for some reason after a username change it added that extra space before or after ...weird right? ...

[KGodel]

Hmm, I will double check. Before the change we disabled spaces in usernames, but the system may have added them. I will have to check the names to see. Thanks for the tip CheechDogg.

Double checked, no spaces. Ran an UPDATE with TRIM just to be sure.

The error remains.

[CAG CheechDogg]

Hmmm.... at one point I did have a few people that kept running into the "incorrect password" and "account does not exist" messages, do you have to have tapatalk for your forums ? ... I noticed that most of the members who got these messages created an account on taptalk and somehow when they logged in through taptalk and they already had an account on the forums it created this issue ... might want to take a look at that my Man ...

[KGodel]

We do have Tapatalk installed, but no accounts were created on it (or if they were it is only some, not all of the errors).

[Lynne]

How about a link to a broken profile? Do you have a link to their correct profile? and can you tell us the username? And have you checked the database to make sure the username and userid are correct for the user? Have you tried to manually change the username in the database to make sure it is exactly what you think it should be?

[KGodel]

I am engaged in getting my staff to start sending me the names of those who are affected.

This user had the issue today and was unable to retrieve his password through the system: http://www.zealotgaming.com/forum/member.php?u=4818

I manually sent an email from the admin panel and he was able to use that.

I have manually edited the database users, tried to manually input a new password via the Admin Panel. I have changed the email, etc. None of these things work except the method I described above, and that only works about half of the time.

[CAG CheechDogg]

Well that sucks ... I have run out of ideas my Man .... any new plugins you might of added around the time that you started having this issue? ....

[tbworld]

The real problem here is the lack of data that we have to work with. Using a copy of your old database and comparing some of the new working entries might give you a test base that may lead to the creation of a "cleaner". Along with the questions @Lynne posted, I have questions like: is it a character-set encoding problem, a collation problem? Performing small tests will answer these questions. There is not going to be a simple answer forthright, unfortunately. :)

[KGodel]

I have very little data myself. I suppose I will just keep manually resending the password email for users and hope that solves the issue.

[tbworld]

If you start saving your database before the email and after the user makes his changes -- you will have one dataset. Three sets of data should be enough for the beginning of a pattern. :)

[Lynne]

I am engaged in getting my staff to start sending me the names of those who are affected.

This user had the issue today and was unable to retrieve his password through the system: http://www.zealotgaming.com/forum/member.php?u=4818


I cannot see the page, so I can't make any other suggestions.