Attachment thumbnail cannot be viewed

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.

Problem

If the attachment folder is accidentally deleted and later restored, the thumbnail image for most of the attachments cannot be viewed in the old tickets. Newly added attachments won't have this issue.

Solution

Run the below query in the DB to update the thumbnailable value to 1 for the required file types that you want to see thumbnail for:

UPDATE fileattachment set thumbnailable = 1 where thumbnailable = 0 and mimetype in ('text/html','image/png')

The below query can be used to find the distinct types of attachments available in the Jira

select distinct mimetype from fileattachment ;
  • Please note that these queries were designed for Postgres DB and you may need to modify them as per your DB type.
  • Always backup your DB before running any Insert/Update/Delete statements in the DB



Last modified on Aug 18, 2021

Was this helpful?

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