Update Modules results in caches is marked as crashed and last automatic repair failed

[alan]

Sorry to bother you clever people...

TL;DR

I need to re-create or fix somehow the caches table in PW

Detail

I have a site [PW v 2.5.3] with a database table that is clearly unwell.

If I go to

Admin > Modules

and click 'Refresh' then this error is reported:

SQLSTATE[HY000]: General error: 144 Table './tsspw/caches' is marked as crashed and last (automatic?) repair failed

I have tried using phpmyadmin, selecting the table and using 'Repair' but it fails.

Also, if I try to backup the database over SSH with Navicat.app (a very good MySQL app for Mac) then it reports:

[Msg] [Bak] Starting backup...
[Msg] [Bak] Gather Information
[Err] [Bak] Get Table `caches` Row Count:
Table './tsspw/caches' is marked as crashed and last (automatic?) repair failed
[Msg] [Bak] Finished unsuccessfully

Thanks for any pointers as to how I can solve this, cheers, -Alan

[horst]

can you delete all rows from the table caches via phpmyadmin?

or, if not, can you delete the table caches and create a new one:

CREATE TABLE `caches` (
	`name` VARCHAR(255) NOT NULL,
	`data` MEDIUMTEXT NOT NULL,
	`expires` DATETIME NOT NULL,
	PRIMARY KEY (`name`),
	INDEX `expires` (`expires`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;

This should solve it. After hitting refresh, it rows should be populated again.

[alan]

Will go and try horst. THANK you for the quick and super helpful post.

[alan]

horst, you're a star Thank you. I was tempted to drop the table but being unfamiliar I was reticent.

I found I could not delete it's rows as phpmyadmin came back with an error. However I selected the table and deleted it via phpmyadmin and then used the SQL you provided. The table was re-created and after logging in and doing a check for new modules the table now has some healthy looking rows and data. Also now the remote backup via Navicat works.

Thank you!