Linux
[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!