XF 2.3 MySQL query error [1034]

[ibrian]

I'm currently having issues with one of my forums - I come in and instead of the forums I get the following message:

An unexpected database error occurred. Please try again later.

A look at the source code comes up with this:

<!-- MySQL query error [1034]: Index for table &#039;xf_ip&#039; is corrupt; try to repair it -->

I tried to use the "repair" function in phpmyadmin, but I get the following message for what looks like all tables:

The storage engine for the table doesn't support repair

Could I please get advise on how I can fix this? The webhosting company I use is proving very slow to resolve the issue each time it happens.

 

[Rene_V]

This type of error usually occurs when you attempt to repair an InnoDB database table due to InnoDB storage engine not supporting repair.

You can give InnoDB recovery a try instead. For more please see this link.

MySQL :: MySQL 8.0 Reference Manual :: 17.18.2 InnoDB Recovery

dev.mysql.com