When I try to upgrade from 3.8.9 (yes, yes, overdue, I know), I hit an error:
Executing _1228 failed. Check system logs.
That log gives me this:
2019-05-21T17:46:58Z:LOG_ERR:76ebca92b3:dba_driver.php:459:db_logger: dba_pdo: ERROR: ALTER TABLE `item` ADD `summary` mediumtext NOT NULL
SQLSTATE[HY000]: General error: 1034 Incorrect key file for table 'item'; try to repair it
It seems that table "item" contains errors, but mysqlanalyze doesn't find any. Repairing InnoDB tables seems to be (almost?) impossible anyway, but someone suggested this trick:
create table <new table> like <old table>;
insert <new table> select * from <old table>;
truncate table <old table>;
insert <old table> select * from <new table>;
That didn't do the trick either. What do I do next, what's wrong with that table, if anything?