I am facing the error some page of frontend. I have tried all solution but issue is still there.

enter image description here

tried Magento 2 theme giving error Unable to load theme by specified key: 'Yogesh/mytheme'.

please help !!

2 Answers 2


Please check

  • theme

  • core_config_data table for theme entry

  • eav_attribute

  • catalog_product_entity_varchar

  • catalog_category_entity_varchar

  • cms_page

  • design_change

for assign theme to products,categories,cms pages, custom design.

  • thanks for the answer. eav_attribute, catalog_product_entity_varchar, catalog_category_entity_varchar these 3 tables worked for me. Feb 21, 2020 at 12:25
  • @DimplePanchal Great Feb 21, 2020 at 13:34
  • plz vote my question :P Feb 21, 2020 at 13:38

Maybe in core_config_data contain wrong active theme.

Try to find

select * from core_config_data where path like '%theme%';

and check that theme exist into theme table if not then try to change theme id and check it

  • no I have already checked that. see the link I have shared in my question. Feb 21, 2020 at 12:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.