Magento #1146 - Table doesn't exist

I faced a very irritating issue. When I logged in phpmyadmin and looked at a table in left column the table shows. But when I try to open that table by clicking on it , it throws error "#1146 - Table `DB NAME.tag_summary` doesn't exist "

I tried to drop the table and create the table again but it throws same error "#1146 - Table `DB NAME.tag_summary` doesn't exist".

Below is the solution:

You would need to access the server via SSH and after that navigate to /var/lib/mysql and go to the database folder.

For eg: cd /var/lib/mysql/DATABASE Folder and then delete the table using

rm -rf DB NAME.tag_summary

rm -rf DB NAME.tag_summary.ibd

rm -rf DB NAME.tag_summary.frm

Then connect to mysql by using the command mysql and follow the below steps:

use DB NAME;

DROP TABLE DB NAME.tag_summary;

No comments:

Post a Comment