# Bug DREAM-112 - Menu Transparent for existings user afer db upgrade to 14.3.0 from 9.x

Project: Stream Design System
Status: closed
URL: https://community.openproject.org/work_packages/DREAM-112

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 14.6.0 |
| Observed in versions | 14.3.0 |
| Sprint |  |
| Backlog bucket |  |
| Bug found in version (deprecated) | 14.3.x |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable | Aaron Contreras |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

Menu Transparent for existing user afer upgrade to 14.3.0 from 9.x ( with 10.x as in between step ), new users or guest work fine.

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/121225/content">

For some users the `default` theme is set in their preferences which no longer seems to be valid, see

**/var/db/openproject**$ psql -U openproject -d openproject&nbsp;  
psql (13.15 (Debian 13.15-1.pgdg120+1))   
Type &quot;help&quot; for help.

openproject=# select \* from user\_preferences;

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/121226/content">

valid themes seem to be light and light\_high\_contrast.

Editing all user profiles and choosing a theme or

Executing the follow psql sorted the issue out manually:

`openproject=# UPDATE user_preferences`   
`SET settings = jsonb_set(settings, '{theme}', '"light"', true)`   
`WHERE TRUE;`
