XF 2.0 XF\Db\Exception: MySQL statement prepare error [145]:

[craigForo]

I'm getting the following server error. Not sure how to go about resolving this.

XF\Db\Exception: MySQL statement prepare error [145]: Table './scholllo_xenforo/xf_stats_daily' is marked as crashed and should be repaired. src/XF/Db/AbstractStatement.php:212

Generated by: Unknown account Mar 10, 2018 at 9:47 PM

Any help appreciated.

 

[Black Tiger]

I was trying to simplify my answer to what I gathered the experience level of the OP was. I did not want to blow them away with more info than I believed was necessary.

Ah oke I thought my answer was short and simple enough even very clear as to where to find it.

I thus wondered why you put your answer right below as it said nothing new. But I now just seen you were most likely writing the same moment that I posted, so you probably didn't see my post before.

 

[Harvey]

PHPmyadmin
Backup / Copy current database
Select current database
Select Structure
Check the left check box on the xf_stats_daily table
Select Repair table in the drop down at the bottom of the table list

View attachment 301249

I found this in hostgator and followed your instructions and it is fixed.

Thank you very much!

 

[philmckrackon]

I found this in hostgator and followed your instructions and it is fixed.

Thank you very much!

Glad it worked. Will you mark that post as solved for others?

 

[Harvey]

Will you mark that post as solved for others?

Yes. Can you show me how?

 

[⭐ Alex ⭐]

Glad it worked. Will you mark that post as solved for others?

The member you helped was not the original poster. That was back in 2018.