Thursday 4 May 2017

SQLSTATE [HY000]: General error: 145 Table catalogsearch_fulltext is marked as crashed in Magento

I was working on magento 1 project and when I tried to save product from admin, I faced one issue while save.

I got error:

SQLSTATE[HY000]: General error: 145 Table catalogsearch_fulltext is marked as crashed and should be repaired.


This error was because of database table crash and it can be solve by table repair.

Database table can be repair by 2 methods:
1. Repair table from phpmyadmin.
-> Log in to cpanel.
-> Select checkbox before table catalogsearch_fulltext.
-> Go to bottom of the page, there will be drop down. select "Repair Table".
-> You are done.

2. You can repair table by ssh command:
REPAIR TABLE catalogsearch_fulltext;


After table I have checked product save from admin. it works smoothly.