Thread

After an un-elegant power outage on our vmware host, our EE install on became corrupted: one table in particular:exp_security_hashes.

MySQL ERROR:

Error Number: 144

Description: Table './webley/exp_security_hashes' is marked as crashed and last (automatic?) repair failed

Query: INSERT INTO exp_security_hashes (date, ip_address, hash) VALUES (UNIX_TIMESTAMP(), '192.168.9.32', 'c7da7f7ce733efa58b156cee11506e0de0f9cc9c')

I am unable to login to EE and gain any sort of control. I do not have a recent backup of the EE database alone. While I do have a recent backup of the entire VM, it will take days to restore it using our old copy of Veeam.

I am wondering if I might be able to manually rebuild this table in phpmysql and if so what the table structure is?

Any other thoughts would be appreciated.

Thanks

dpotter2,

What version and build of EE are you using?

Are you able to try a repair of the table via phpMyAdmin or similar?
Backup what you have first so at least you have that as a fallback.

Thanks,
We applied a SWAG factor and took some guesses at the field names and types.
All is well once more.

Glad you were able to fix the problem. Don’t hesitate to post again as needed.