Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-26782

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

XMLWordPrintable

      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.

        1. notificationworkbox.jpg
          notificationworkbox.jpg
          39 kB

          Form Name

            [CONFSERVER-26782] Workbox Notifications and Personal Tasks URLs are stored as an absolute path in the database

              etom edith (Inactive)
              hsuhailah Hanis Suhailah (Inactive)
              Affected customers:
              3 This affects my team
              Watchers:
              10 Start watching this issue

                Created:
                Updated:
                Resolved: