How can I search for all instances where a specific theme has been applied?

Issue

• I have applied a specific theme to certain pages and would like to update the theme to a new one. However, I am not sure which pages / layouts have my theme has been applied.
  • When I remove my previous theme and update to my new theme, I am seeing this warning:

    WARN [https-jsse-nio-4443-exec-7][ThemeLocalServiceImpl:220] No theme found for specified theme id Sample_theme. Returning the default theme.

• Is there a way to search and identify where my previous theme has been applied so that I can remove all instances of my old theme to address the warning?

 

Environment

• Liferay 2024.Q3

 

Resolution

• Themes applied can be found in the following tables within the database:
  • Layout
  • LayoutRevision
  • LayoutSet
  • LayoutSetBranch

• You may query these tables to search for your desired theme. A sample query such as the following would work:

• SELECT * FROM Sample.Layout
  WHERE themeId LIKE '%MyTheme%' ;

 

Additional Information

• Liferay Learn: Changing Your Site's Appearance