This page last changed on Dec 05, 2010 by sjayaraman.

Later versions of Confluence may deprecate older themes. Spaces that are configured with this theme will be migrated automatically to a new theme, during the upgrade process. In some scenarios, this may not happen, hence you can fix this by following this guide.

In this guide, we are using Left Navigation Theme as an example of deprecated theme (if you are trying to find another theme, please replace the LIKE section to the respective theme). The following SQL query will list all spaces with the :

SELECT s.spacename, s.spacekey FROM spaces s 
WHERE s.spacekey in  (
SELECT bandanacontext FROM BANDANA 
WHERE bandanavalue LIKE '%<string>com.atlassian.confluence.themes.leftnavigation:leftnavigation</string>%' AND bandanakey = 'atlassian.confluence.theme.settings'
)

In order to change all spaces that uses Left Navigation Theme to the Default Theme, use the following query:

UPDATE BANDANA SET bandanavalue ='<map>
  <entry>
    <string>theme.key</string>
    <string></string>
  </entry>
</map>' WHERE bandanavalue LIKE '%<string>com.atlassian.confluence.themes.leftnavigation:leftnavigation</string>%' AND bandanakey = 'atlassian.confluence.theme.settings';

Flush Confluence/browser cache after executing the query.

Document generated by Confluence on Mar 16, 2011 18:51