Attachment thumbnail cannot be viewed
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
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
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:
1
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
1
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
Was this helpful?