https://confluence.atlassian.com/pages/viewpage.action?pageId=329974322
Broken avatars/icons in Confluence after an upgrade due to corrupted cache

Also check Base URL in database table BANDANA, bandanakey='atlassian.confluence.settings'

This issue is a duplicate of CONF-22298. Please see that issue for more information and a workaround.

I also got the same problem with profile pictures getting lost when I'm upgrading from confluence-3.4.9 to confluence-3.5.13 on my way to confluence-4.1. The profile pictures are still available in confluence, but each user has to go to his/her profile settings to enable the picture again. I've tried the SQL query above and possible solutions from https://jira.atlassian.com/browse/CONF-17247 and https://jira.atlassian.com/browse/CONF-22298, but I still can't get the profile pictures to display by default.

Any help would be appreciated!

Hi,

We have the same issue when updating from 3.3.1 to 3.5.13 with oracle database.

I tried the workaround purposed by Mangesh Phadnis but noting has been inserted, the BD is correct.
And the picture is not loose for all profiles...

any news about this problem ?

Regards

We are having the same problem on mysql migrating from conf 3.3 to 3.5.9.

Any Hint how to "repair" this on mysql?

thanks

Our ever helpful Data Modeler/Architect Chris Katrichis has provided the below workaround. This worked for us, but please run in your test environment first if you plan to use it.

– This is for an Oracle database
– Confluence 3.5.9 workaround to enable profile pictures
– Add an entry for each row with entity key of 'confluence.user.profile.picture' with entity_id = 0
– Replace “confluence” with the name of the schema you use for the confluence software
–

insert into confluence.os_propertyentry(entity_name, entity_id, entity_key, key_type, boolean_val, double_val, string_val, text_val, long_val, int_val, date_val)
select entity_name, 0, entity_key, key_type, boolean_val, double_val, string_val, text_val, long_val, int_val, date_val
from confluence.os_propertyentry osp1
where entity_key = 'confluence.user.profile.picture'
and string_val is not null
and not exists( select 1 from confluence.os_propertyentry osp2
where osp2.entity_name = osp1.entity_name
and entity_id = 0
and entity_key = 'confluence.user.profile.picture');
commit;

This also seems a problem when upgrading from 3.2.1 to 3.5.