Top navigation bar disappears after upgrade

Still need help?

The Atlassian Community is here for you.

Ask the community

This article only applies to Atlassian's server products. Learn more about the differences between cloud and server.

 

Problem

After upgrading JIRA, the top navigation bar has disappeared. The issue only happens to few users. For other users, the top bar shows up fine.=

There is nothing strange in the logs.

 

Diagnosis

For the users that do not have the top navigation bar also have a broken avatar in their profile page.

Searching for the default avatar id in the database returns null : 

select * from propertystring where id in (select id from propertyentry where property_key like '%avatar.user.default%'); 

Cause

The default user avatar setting is missing in the instance. This is the reason why the avatar for these users is broken. Due to the same reason, the top navigation bar is also missing.

Resolution

In order to fix the issue we need to insert the default user avatar in the database : 

  1. Run this query in the database and note the id: 

    select id from propertyentry where property_key like '%avatar.user.default%' ;
  2. Run this query  and note the id: 

    select id from avatar where filename like 'Avatar-default%'; 
  3. Insert the following data in database  

    insert into propertystring values (<id from step 1>,<id from step 2>);

Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

 

Last modified on Mar 10, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.