1UPDATE `tiki_preferences` SET `name` = 'theme' WHERE `name` = 'theme_active'; 2UPDATE `tiki_preferences` SET `name` = 'theme_option', `value` = REPLACE(`value`, '.css', '') WHERE `name` = 'style_option'; 3UPDATE `tiki_user_preferences` SET `value` = REPLACE(`value`, '.css', '') WHERE `prefName` = 'theme'; 4UPDATE `tiki_user_preferences` SET `prefName` = 'theme_option', `value` = REPLACE(`value`, '.css', '') WHERE `prefName` = 'theme-option'; 5UPDATE `tiki_theme_control_categs` SET `theme` = REPLACE(`theme`, '.css', ''); 6UPDATE `tiki_theme_control_objects` SET `theme` = REPLACE(`theme`, '.css', ''); 7UPDATE `tiki_theme_control_sections` SET `theme` = REPLACE(`theme`, '.css', ''); 8UPDATE `users_groups` SET `groupTheme` = REPLACE(`groupTheme`, '.css', ''); 9