I have deleted a user with username = “XXX” and I want yo change the username of other user with the same username of deleted user but I can not. I get the mensagges. “Username have to be unique” How can I check if a username is taken or not complete deleted? Regards

You can go in your admin → users → filter by username. Alternatively, you could use data explorer .

Yes, I have deleted the user from admin–>users but After that I can not use the same username that I removed

Then try using data-explorer and execute this request: SELECT username FROM users WHERE username LIKE '%username%' Might give some clue.

No results. But when I try to use the username of a user deleted I get the messages that username must be unique. Other table where can be that username?

I don’t know. What is the username you’re trying to use? Maybe you try a reserved username, but I guess you’d have a different message… Also the previous user woudn’t have been able to choose it :man_shrugging:t6: Here’s the code that checks if a username is already taken: USERNAME_EXISTS_SQL …

Do you have a group with this name? @Canapin is correct that users and groups share a namespace.

No, I have not any group with the same name. Another thing is that I can mention in DM messages username of deleted users.

ユーザー名を削除したが、他のユーザーでそのユーザー名を使用できない

製品サポート

Canapin (Coin-coin le Canapin) 2020 年 4 月 11 日午前 9:47 2

管理者画面の「ユーザー」からユーザー名で絞り込むことができます。
または、データエクスプローラーを利用することもできます。

トピック		返信	表示
Deleted user can signup for an account but with the same username they had Product Support	1	1155	2023 年 8 月 28 日
Username changed after Discourse upgrade Product Support	2	881	2018 年 7 月 11 日
Critical Error: changed username, user got broken Product Support	18	2001	2020 年 3 月 15 日
Groups can be given same name as existing username Bug	3	1163	2018 年 6 月 12 日
Usernames suddenly have 1 appended to end Product Support	3	567	2018 年 8 月 15 日

ユーザー名を削除したが、他のユーザーでそのユーザー名を使用できない

関連トピック