XF 1.5 Database error for xf_search_index

[Dadparvar]

Hi,

Today I get this error:

Mysqli prepare error: Table './mydb_xf/xf_search_index' is marked as crashed and last (automatic?) repair failed

And I also repair it from phpmyadmin, but it says:

mydb_xf.xf_search_index
repair
error
Can't create new tempfile: './dadparva_xf/xf_searc...
mydb_xf.xf_search_index
repair
status
Operation failed

Any opinion will be appreciated

 

[Paul B]

If you can't repair it, rebuild it in the ACP and select the option to delete the index first.

You should contact your host and ask them to investigate what caused the crash - typically it's due to server issues such as MySQL restarting unexpectedly.

 

[Dadparvar]

typically it's due to server issues such as MySQL restarting unexpectedly.

Its a dedicated server.
And this caused the problem. Yesterday because of a problem suddenly that happened.

rebuild it in the ACP and select the option to delete the index first.

Done and fixed.

Thanks