How to retrieve older version of JPG attachments

Still need help?

The Atlassian Community is here for you.

Ask the community

This article only applies to the Atlassian server platform. Learn more about the differences between cloud and server.


Problem

The older version of JPEG attachments isn't accessible from the Confluence UI. Even clicking on the older version from attachment page will only display the latest version of JPEG file

  1. Navigate to Confluence Page > Attachments.
  2. Attach the first version of the JPG image in the attachment.
  3. Attach the second version of the JPG image in the attachment with the same attachment name.
  4. Click to preview the first version of the JPG image.

Environment

  • All versions of Confluence regardless of the environment

Cause

Confluence preview URL is having the parameter version=1 while accessing the second version (latest) of the JPG image

{code}<BASE_URL>/download/attachments/1966087/example.jpg?version=1&amp;modificationDate=1509703152000&amp;api=v2{code}

Workaround

This is a known bug  CONFSERVER-54125 - Getting issue details... STATUS  and the only workaround is to change the format to .png.To access the older version, we would need to manually change the format from .JPG to .PNG in the database

  • Note the CONTENTID of the JPG image

    select contentid from content where title = '<JPG attachment title>' and contenttype='ATTACHMENT'
  • Update the CONTENT table by replacing .jpg in the title by .png

    update content set title='<title of attachment>.png',lowertitle='<title of attachment>.png' where
    contentid in (select contentid from content where title = '<JPG attachment title>' and contenttype='ATTACHMENT')
  • Update the CONTENTPROPERTIES table to change the MEDIATYPE property

    update contentproperties set stringval='image/png'  where  propertyname='MEDIA_TYPE' and contentid in (select contentid from content where title = '<JPG attachment title>' and contenttype='ATTACHMENT')
  • Flush the Cache or Restart Confluence to see the changes in UI

    Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.


Last modified on Nov 25, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.