Workbox Notifications and Personal Tasks URLs are stored as an absolute path in the database

When updating Confluence sever base URL under General Configuration, the existing URLs of Notifications and Personal Tasks in Workbox did not get updated and they continue to use the old URL. It appears that these URLs are stored as an absolute path in the database.

The item URL and icon URL are also stored in an absolute path format. When a user update his/her Profile Picture, it does not get reflected in the Workbox.

The URL stored in the database should not include server base URL. At times, an organization is required to change domain name or port number and when this new changes are not reflected on the existing Notifications and Personal Tasks in Workbox, the URLs re-direction are broken and these links became unusable.

Workaround:

Manually update the links/urls from the database. You may refer to the following query for reference (you may need to adjust the value accordingly):

UPDATE ao_9412a1_aonotification
SET ICON_URL='<new url>', ITEM_URL='<new url>', URL='<new url>'
WHERE ID=<number>;

Warning:

Before performing the changes, please backup your database for precaution measure.

Update

Tested on Confluence 4.3.6, only the URL column in the AONOTIFICATION table is still using absolute path. ICON_URL, ITEM_URL is now using relative paths. With that said, the only link broken is shown in the following screenshot:

The only link that's broken is the Open link at the bottom of the notification. Rest of the links are now working as it should despite the change in Base URL.