Attachment thumbnail cannot be viewed
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