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? ...