Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-65639

Images are broken and not displaying correctly on Cloud instance after migrating from on-premise

XMLWordPrintable

      After migrating from on-premise to Cloud, large images doesn't render properly in pages on Cloud.
       

      This image is too large to apply effects. Please make it smaller (less than 4,000,000px in total dimensions) and try again.

      Workaround:

      • Run below SQL on the on-premise to get all the pages in which there are large images which has effects enabled on them. 
        select 
	spaces.spacename, parent_content.title AS "Page Title", content.title AS "Image Title",
        i.height, i.width, i.height * i.width AS "Pixels Size",
       ROUND(contentproperties.longval/1024/1024, 2) AS "file_size (MB)"
from 
	content 
	inner join contentproperties on content.contentid = contentproperties.contentid
	inner join content parent_content on content.pageid = parent_content.contentid
	inner join spaces on content.spaceid = spaces.spaceid
	inner join bodycontent on content.pageid = bodycontent.contentid
        inner join imagedetails i on content.contentid = i.attachmentid
where 
	content.contenttype = 'ATTACHMENT'
	and contentproperties.propertyname = 'FILESIZE'
	and parent_content.content_status = 'current'
	and content.prevver is NULL
	and bodycontent.body like '%ac:image ac:queryparams="effects=%'
	and contentproperties.contentid in (select contentproperties.contentid from contentproperties where stringval like 'image%')
        and i.height * i.width >= 4000000
order by contentproperties.longval desc;
      • After the migration, go to Cloud instance, and open the page in edit mode, click on the broken image in edit mode and choose "Properties" then remove the effect (change it to none instead of having a border).

            [CONFCLOUD-65639] Images are broken and not displaying correctly on Cloud instance after migrating from on-premise

            No work has yet been logged on this issue.

              b2e61339283b Ben Keene
              vvisanakarrala Veera (Inactive)
              Affected customers:
              11 This affects my team
              Watchers:
              19 Start watching this issue

                Created:
                Updated:
                Resolved: