I posted this query a few days ago, but it has been deleted for some reason - so apologies in advance. After a recent Discourse update, my posts are showing the ‘Name’ of a poster twice. Please see this live example - https://businesscomputingworld.co.uk/t/schneider-electric-products-win-six-prestigious-if-design-awards/284544 Screenshot also attached. [Screenshot 2020-03-06 at 13.47.42] I believe this is a database problem??? I am not a developer so can’t created scripts etc. Can anyone provide any help to sort this please?

Not sure if it’s the best/correct way to do it, but I ‘disabled names’ in admin and it sorted the problem :slight_smile:

I think it was deleted because it was not directly Discourse related. I discussed with your colleague Ravi via direct message about how to fix this though I didn’t have any follow up. It can probably be fixed with a short rails script that will compare names and usernames and split name if needed. Were these users imported? If they were how did you import them? Since this topic may also be meant to be deleted, I’ll send you a direct message too.

[image] christian_01: I believe this is a database problem??? I suspect that you have the name duplicated in the name field.

Don’t know really. It was fine, then it wasn’t. Nothing changed my end - hundreds of user names just appeared twice on my site. I can only assume it was due to a Discourse update.

We run many hundreds of Discourse instances, all updated very frequently. Meta is also visited by many people running Discourse independently. You are the only one reporting duplicated names, which means this is caused by unique circumstances on your instance.

[image] christian_01: Can anyone provide any help to sort this please? I wonder if the original topic was also deleted because people are asking questions to try to diagnose the problem and suggest a probable solution but you don’t give a direct answer here. So the topic becomes a lot less useful for anyone else with the same problem because the current situation is not clarified and the underlying cause never gets identified. For example: [image] Canapin: Were these users imported? If they were how did you import them?

If you look at the user profile pages is the name duplicated? Does the problem persist in safe mode?

Apologies @Remah, I thought I had explained how I sorted the problem. Replying to @Canapin, no I haven’t imported any users, I have done nothing apart from update Discourse.

[image] christian_01: I had explained how I sorted the problem. We’re interested in what caused it. You probably still have a problem with your user data. If so then you’ve just suppressed its display.

Duplicate 'Names'

Product Support

itsbhanusharma (Bhanu Sharma) March 8, 2020, 2:51am 11

Hey @Remah

They’re running some highly customised set of once off plugins and any one of those may have caused this.

Topic		Replies	Views
Upgrade issue with duplicate username in DB Self-hosting	2	557	January 29, 2021
So many broken users due to corrupt database Product Support	16	1691	April 27, 2020
Usernames getting modified – numeral "1" being added SSO	4	1445	September 11, 2018
Generic “userN” usernames Product Support	12	2684	October 27, 2021
Critical Error: changed username, user got broken Product Support	18	2020	March 15, 2020

Duplicate 'Names'

Related topics