Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-41513

Cannot display more than 100 comments on attachment

XMLWordPrintable

      Summary

      Cannot display more than 100 comments on attachment.

      Environment

      Confluence 5.9.9
      PostgreSQL database

      Steps to Reproduce

      1. Add 101 comments to an attachment
      2. Close the attachment preview
      3. Preview the attachment again

      Expected Results

      101 comments would show

      Actual Results

      Only 100 comments are shown no matter how many more are entered

      Notes

      This query reveals that the comments are being stored in the database, but not displayed:

      select * from CONTENT c1
join CONTENT c2 on c1.CONTENTID = c2.PAGEID
join CONTENTPROPERTIES cp on c2.CONTENTID = cp.CONTENTID
where cp.PROPERTYNAME = 'status'
and c1.CONTENTID = <content ID of attachment>;

      In the query, replace <content ID of attachment> with the ID for the affected attachment. To get the ID:

      1. preview the attachment by clicking on it on the page
      2. copy the second number after "preview=/" for example, 557061 in this URL: preview=/98307/557061/1/557081/test.xlsx

      Workaround

      There is no workaround.

            [CONFSERVER-41513] Cannot display more than 100 comments on attachment

            Khurram Amin added a comment -

            Users came to know that there are 180 comments on the document and 80 out of 180 were lost as they didn't realize that comments are not getting saved after it reached to 100 comments

            I will be really helpful if Atlassian can bring those lost comments back and the database tables show comments are getting saved in table but confluence is unable to display them

            Khurram Amin added a comment - Users came to know that there are 180 comments on the document and 80 out of 180 were lost as they didn't realize that comments are not getting saved after it reached to 100 comments I will be really helpful if Atlassian can bring those lost comments back and the database tables show comments are getting saved in table but confluence is unable to display them

              Unassigned Unassigned
              aworley Ann Worley (Inactive)
              Affected customers:
              5 This affects my team
              Watchers:
              6 Start watching this issue

                Created:
                Updated: