Users from Active-Directory in Confluence coming up twice in @mentions

skorzinetzki

Hey,

like the title says:

When I use the @mention functionality on a page or comment, the auto-completer shows users from the Active-Directory twice. The links behind these users, which point to their profiles, are different. For example:

I want to mention myself (my username is sko) it shows up my name twice and the links to my profile are "~SKO" and "~sko" (upper case vs. lower case).

There might be the problem, that our Active-Directory ships only upper-case usernames.

How can I avoid showing up the usernames twice?

Fabrizio Galletti

it's a problem releted to the alredy indexed content on confluence table, i'm out of office and i can write you only something that i remember:

indexed content will be saved on "content" table of your database.

Indexed users (the whom u find in search, mention etc) will be here too.

with this query

select * from CONTENT where CONTENTTYPE<>'USERINFO';

u can find who is indexed here. for example if u have added 2 active directory and so 2 user are added or u have worked with renaming user, u can have 2 row with the same username.

U can delete from here and reindex, but as you alredy know, you are deleting directly from DB, backup and test it before going live.

hope it helps, i don't have my documentation here