SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XXX.tag_summary' doesn't exist, query was: SELECT tag_summary.popularity, tag.* FROM tag_summary INNER JOIN tag ON tag.tag_id = tag_summary.tag_id AND tag.status = 1 WHERE (tag_summary.store_id = '1') AND (tag_summary.products > 0) ORDER BY popularity DESC LIMIT 20

  • Please ask for trace if required.
    – close2zero
    Commented Jan 13, 2016 at 9:32
  • Ensure your database tables don't have prefixes, could be the cause. Please double check that the tag_summary table exists in your database. Commented Jan 13, 2016 at 9:33

1 Answer 1


Here you can find the SQL to create the missing table : http://pastebin.com/JipuLqRt (take care if you have table prefix)

Like my response here : https://magento.stackexchange.com/a/96630/33619 one solution you have to fix this kind of error is to install a clean Magento instance and use PhpMyAdmin (or other tool) to see table structure. With that you can find the SQL query to create the table.
For example I am using Sequel Pro and there is a tab for this :
enter image description here


Your Answer

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

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