When there is the need to reset the themes for all IBM Connections Communities
to the default one you can use the following SQL commands.
Only setting the theme in the SNCOMM Communities database isn’t sufficient as
theme choices are also saved in some of the sub components of Connections.
This goes for Activities, Blogs, IdeationBlogs, Forums and Wikis.
“UPDATE COMMUNITY SET COMMUNITY_THEME = ‘default’;”
“UPDATE LIBRARY SET THEME_NAME = ‘default’;”
“UPDATE WEBSITEASSOC SET ASSOCTHEME = ‘default’;”
“UPDATE DF_MEMBERPROFILE SET THEMEID = ‘default’ WHERE THEMEID is not null”
“UPDATE OA_MEMBERPROFILE SET THEMEID = ‘default’ WHERE THEMEID is not null”