Hard reset for Community themes in IBM Connections

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.

Communities:

“UPDATE COMMUNITY SET COMMUNITY_THEME = ‘default’;”

Wikis:

“UPDATE LIBRARY SET THEME_NAME = ‘default’;”

Blogs:

“UPDATE WEBSITEASSOC SET ASSOCTHEME = ‘default’;”

Forums:

“UPDATE DF_MEMBERPROFILE SET THEMEID = ‘default’ WHERE THEMEID is not null”

Activities:

“UPDATE OA_MEMBERPROFILE¬† SET THEMEID = ‘default’ WHERE THEMEID is not null”

 

 

This entry was posted in ibm connections and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

Please leave these two fields as-is:

Protected by Invisible Defender. Showed 403 to 813,217 bad guys.