[How To] Fix error SQLSTATE[42S02]: Base table or view not found

Magento is one of the widely used eCommerce software now a days.

Many of you may face issues with Magento while upgrading the version or installing themes.

And when the problem comes with MySQL probably it's your bad time going on.. 😛

One of the error faced by me was

Mysqli prepare error: Table ‘magento.core_config_field’ doesn’t exist

After doing R&D, a post on the magento forum helped me to fix the issue.

The issue was related to Magento cache

1) Go to cache directory of your Magento installation

cd /var/www/html/magento/var/cache

2) Clear the contents in cache directory

rm -rf *

3) Refresh the webpage and see the magic.

*You may rename existing cache directory and create a new cache directory with same ownership and permission so that changes can be reverted at any point if not successful.

If any feedback, queries are always welcome!

Share on Facebook0Share on Google+0Tweet about this on TwitterShare on StumbleUpon1Share on LinkedIn0Share on Tumblr0Pin on Pinterest0Email this to someonePrint this page

About Abhijit Sandhan

Abhijit Sandhan

Loves Linux, Blogging, Traveling, Hiking and sharing Knowledge!

Leave a Reply

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