Craft: Searchindex table crashed
Upload failed. The error message was: “SQLSTATE[HY000]: General
error: 145 Table './craft/searchindex' is marked as crashed and
should be repaired
The SQL being executed was: SHOW FULL COLUMNS FROM
What is happening?
This error occurs when there is a problem with the searchindex table. The craft_searchindex table is the only table that uses MySQL's older MyISAM storage engine, instead of InnoDB, which can crash easily.
The quickfix for this issue is to login to phpMyAdmin and execute the following command in the SQL tab:
REPAIR TABLE craft_searchindex;
A more permanent fix, if you know you're running a MySQL version above 5.6.4, you can change the storage engine for that table from MyISAM to InnoDB, with following query, after taking a backup for that table of course:
ALTER TABLE craft_searchindex ENGINE = InnoDB;