It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Why I cannot preview but only download pdf file?

Nicolas Casel Jun 02, 2016

In a wiki page, when I click on a link to a PDF file, the preview is not working:

pdf-preview.png

 

However, I can download the PDF file and it is available in the page attachments list.

Any idea about how to restore the preview?

4 answers

1 accepted

1 vote
Answer accepted
Damien Braz Jun 02, 2016

Hi Nicolas,

 

Here is Confluence Doc:

 

Observed issues are with PDF type attachments, JPEG and PNG images

The following appears in the atlassian-confluence.log

 

 

2015-02-17 07:48:56,813 ERROR [conversion-thread-3-internal] [conversion.impl.runnable.ConversionRunnable] doWork Format cannot be converted


 -- referer: http://testserver:8090/display/TS/Incident+and+Problemmanagement?preview=/17663912/17795772/How%20To%20Code%20In%20Java.pdf | url: /rest/documentConversion/0.1/conversion/convert/17795772/1 | userName: tester

 

Diagnosis

  1. A newly inserted attachments can be previewed by clicking on its link.
  2. The file itself is downloadable

Diagnostic Steps

  • Try to replicate this in all browsers
    1. Navigate to an existing page that has PDF Attachment link embedded
    2. Click on the PDF link
  • Generate a HAR file and check when clicking on the old attachment link. Instead of getting the 'Resource', a 'HEAD' is returned when the command "byAttachmentIds" and "minusAttachmentIds" are sent
  • Run the following SQL query:
    • If there are rows returned, please continue to the Resolution section. If it returns empty result, you are not being affected by the issue in this article. Please contact Atlassian Support to assist you.

 

SELECT * FROM CONTENTPROPERTIES WHERE PROPERTYNAME = 'MEDIA_TYPE' AND STRINGVAL LIKE '%pdf%';

SELECT * FROM CONTENTPROPERTIES WHERE PROPERTYNAME = 'MEDIA_TYPE' AND STRINGVAL LIKE '%pjpeg%';

SELECT * FROM CONTENTPROPERTIES WHERE PROPERTYNAME = 'MEDIA_TYPE' AND STRINGVAL LIKE '%x-png%';

 

Cause

The Content Type of the attachments are wrong

  • PDF Attachment isnot 'application/pdf' as how it should be, instead the Content Type is either in one of this format; 'pdf', 'image/pdf' or 'application/x-pdf'. 
  • JPEG images isnot 'image/jpeg' as how it should be, instead the Content Type is either in one of this format; 'image/pjpeg'. 
  • PNG images isnot 'image/png' as how it should be, instead the Content Type is either in one of this format; 'image/x-png'. 

These values are already invalid before performing the upgrade.

For more information please refer to  CONF-36666 - Unable to Preview PDF Attachment Link Due to Wrong MEDIA_TYPE After Upgrade RESOLVED .

Resolution

Run the following SQL query:

  • For issues with PDF:

     

    UPDATE contentproperties SET STRINGVAL = 'application/pdf' WHERE PROPERTYNAME = 'MEDIA_TYPE' AND STRINGVAL LIKE '%pdf%';

     

  • For issues with JPEG images:

     

    UPDATE contentproperties SET stringval = replace(stringval, 'image/pjpeg', 'image/jpeg') WHERE PROPERTYNAME = 'MEDIA_TYPE';

     

     

  • For issues with PNG images:

     

    UPDATE contentproperties SET stringval = replace(stringval, 'image/x-png', 'image/png') WHERE PROPERTYNAME = 'MEDIA_TYPE';
  • Flush your Confluence caches by navigating through Confluence Administration Panel >> Cache Management >> Flush All.

 

Best Regards, Damien.

2 votes
Tim Colson May 11, 2018 • edited

Hmmm... just ran into this error in the Cloud instance of Confluence for PNG images that were working fine, but after I did an in-place update to one image ("Edit with... Preview (the Mac App). Make a change. Save. Update Confluence. See it on the page. Click PNG to see it larger... and boom. Error. 

In fact, now all images on the page are not preview capable and must download. That's crappy. 

I'm certainly not able to run SQL to check the DB for Cloud Confluence... and all steps I did were above...nothing crazy. 

 

My Answer: Atlassian needs to review the process with us to find the regression bug that's causing the problem and fix Confluence.

Genevieve Cory Aug 01, 2018

Same issue, also in a Cloud Confluence. I don't know who changed what but it's everywhere.

Like # people like this
0 votes
Rodney Hughes Jun 02, 2016

apart from checking the file type itself, I think it is MUCH simpler than all that....

in edit mode of the page, as you hover your mouse over the link text, you will see it gives a pop up that says "show as thumbnail"  - that toggles to "show as link"

Nicolas Casel Jun 03, 2016

I do not want to display the file 'thumbnail' but some text (pdf file name let's say).

By the way, this workaround does not work, the thumbnail is empty and clicking on it displays the same "error" message.

Rodney Hughes Jun 03, 2016

it should work - contact your system admin?!?!?! - here is a test page on our system with two PDF tests

image2016-6-4 6:16:57.png

Rodney Hughes Jun 03, 2016

and here is another "interactive" PDF page using "Insert>Other Macros> PDF   you can click the arrows at the bottom to move through the PDF smile or click the download button bottom left

image2016-6-4 6:21:37.png

image2016-6-4 6:23:13.png

 

 

Nicolas Casel Jun 05, 2016

Thanks @Rodney Hughes

However, the PDF macro displays the  content of the PDF file (like your 2nd screenshot), and in my case I want to display a link like this:

pdf-text.png

Rodney Hughes Jun 05, 2016

when you insert a link to a file (not the interactive PDF macro), you can choose whether to display the file as a link or as a thumbnail

In the Edit mode, if it is showing as a thumbnail, just click or hover the mouse over the thumbnail and a pop up box will appear which toggles as below

image2016-6-6 18:3:2.png

image2016-6-6 18:4:13.png

 

 

Nicolas Casel Jun 05, 2016

Ok, but as I've already written above:

the thumbnail is empty and clicking on it displays the same "error" message.

Rodney Hughes Jun 06, 2016

try another PDF - you may have a corrupt file format

Like Elizaveta Turchaninova likes this
0 votes
Robert Ortner Jun 03, 2016

try a different browser

 

Nicolas Casel Jun 03, 2016

Same result on IE, FF and Chrome.

Like Elizaveta Turchaninova likes this

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

933 views 0 19
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you