XF 2.2 Website down due to error. Hostgator referred back to Xenforo to troubleshoot

[eyereef]

Getting this error: Can anyone help? Thanks

"An exception occurred: [XF\Db\Exception] MySQL statement prepare error [145]: Table './socalire_xenforo/xf_session' is marked as crashed and should be repaired in src/XF/Db/AbstractStatement.php on line 212

 

[Paul B]

Repair or truncate the xf_session table.

It's surprising your host wasn't able to suggest repairing at least.

 

[eyereef]

yes its hit or miss on who i get. this happen 2 days ago and that person was able to help. Error reoccurred next day and the last few people said there was nothing that could be done.

 

[Paul B]

Find a new host - it points to server instability.

 

[eyereef]

I tried the repair but getting a "repair failed". Any other suggestions?

 

[eyereef]

Doesnt look like I have the option to truncate?

 

[MySiteGuy]

Go to the sql tab and run this:

repair table xf_session use_frm;

 

[eyereef]

Looks like im getting an error when I try to optimize and repair xf_session

 

[Paul B]

Doesnt look like I have the option to truncate?

Truncate means empty.

 

[eyereef]

Wow truncate/empty table actually worked! thanks everyone!

 

[Mouth]

Wow truncate/empty table actually worked! thanks everyone!

And now your next step ....

Find a new host - it points to server instability.