Followers and Followees are Lost, But Unable to Re-Add the Users
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Symptoms
Followers and followees for a user are lost in the user's Network tab:
Attempting to add a user to Follow results in the error: "Already Following User"
Diagnosis
Try to How to Rebuild the Content Indexes From Scratch on Unclustered Confluence . If that does not work, run the following queries in the Confluence Database:
1
SELECT * FROM follow_connections WHERE FOLLOWER = '<user_key>';1
SELECT * FROM CONTENT WHERE CONTENTTYPE = 'USERINFO' AND LOWER(USERNAME) IN (SELECT LOWER(FOLLOWEE) FROM FOLLOW_CONNECTIONS WHERE FOLLOWER = 'TGDBIPA4');Replace <username> in both queries with any 1 user that is supposed to be following someone
If the first query returns the correct values for FOLLOWEE (who you are supposed to be following), and if the second query returns a USERINFO entry in the CONTENT table for the correct users, proceed to the next steps, else, request for all the users that are missing as a Followee to login to Confluence to create his/her USERINFO entry, then How to Rebuild the Content Indexes From Scratch on Unclustered Confluence to resolve the issue
Cause
The users that do not appear there do not have the Can Use permission into Confluence via individual/group permissions in Confluence Admin >> Global Permissions
Solution
Resolution
Either add a Can Use permission for any group that the user is member of, or add the permission individually for the user in
Confluence Admin >> Global Permissions. See Global Permissions Overview
Was this helpful?