I just changed the username of a person xxx on their demand. they wanted to take an inactive username yyy. so first I changed the inactive username yyy to somthing else like yyy1 and then changed that person username from xxx to yyy. at this point, first, the user couldnt post anything and I saw th…

Now I cant even open their profile page. Is there somthing I can do to heal this in the meantime? [Screenshot%20from%202019-11-05%2022-48-23] [Screenshot%20from%202019-11-05%2022-45-16]

I’m working on going through the steps you outlined right now. I’ll let you know what I find.

[image] hosna: Job exception: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint “index_users_on_username_lower” DETAIL: Key (username_lower)=(mina) already exists. btw idk why im getting error on this user (username_lower)=(mina) at all. I have never done any change t…

Ok, I ran through the steps. If I did anything different from what you did, let me know. There are two users: xxx (active account) yyy (inactive account) Change yyy to yyy1 Change xxx to yyy ( :white_check_mark: worked for me) Try posting using the new yyy account ( :white_check_mark: wo…

[image] tshenry: Clicking on the avatars of the listed usernames should take you to their current and correct user page. Yes clicking on the avatar takes me to their page. however, it sems to me that their page is kind of inactive. for example I cant display their email or impersonate their a…

I’m trying my best to follow along here. It sounds like a very odd situation! Can you clarify what you mean when you say that their history was totally cleared? Should fatemeh_baghdadi5 have various topics and replies listed under the activity section of their profile? If that is the case, are tho…

[image] tshenry: Can you clarify what you mean when you say that their history was totally cleared? at the moment that I changed the username, I went to their profile and saw no posts, etc. but it got fixed after a while. however now fatemeh74 which actually seems to be the correct person, is…

[image] hosna: I mean as you see, we cant see their profile page, while their post and other things are present. like this: Thanks for posting that example. That’s definitely concerning. [image] hosna: where is this exactly? You can find it listed at /sidekiq/scheduler. It’s worth a s…

[image] tshenry: It’s worth a shot, but based on what you just posted, it sounds like there might be a deeper issue. Unfortunately you are right. It didnt fix my problem.

Critical Error: changed username, user got broken

Support

hosna (hosna) November 5, 2019, 10:13pm 14

@tshenry Is it ok that I can have two username that are exactly the same except for the first word which are uppercase/lowercase?

I think this might be related to the problem.

Topic		Replies	Views
Username already exist error Self-hosting	3	1156	December 11, 2019
So many broken users due to corrupt database Support	16	1556	April 27, 2020
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	24	2334	January 26, 2021
Update quotes and mentions when username is changed Feature	22	4882	February 19, 2021
Username change wipes post history in user profile Support	9	2134	July 5, 2016

Critical Error: changed username, user got broken

Related topics