Remember to take a backup of your site before making any changes to the database!
While we provide these instructions for assistance, we are not responsible for any problems that may result from their use.
The theme and container settings for a page can be set individually via the page's appearance settings. However, sometimes this will lead to issues when changing the theme of your site. In order to set all pages on the site to inherit their theme from the default theme set in the site's admin menu, you can run the following queries under Host>SQL.
To set all pages to use the site's default skin theme:
SET SkinSrc = NULL
To set all pages to use the site's default container theme:
SET ContainerSrc = NULL
To set all modules to use the site's default container theme:
SET TabModules.ContainerSrc = null
These arguments can be modified to affect only certain portals or page ranges as well.