XF 2.2 AbstractStatement MySQL error

[thanks]

Hi, the error pictured below pops up every time someone hits submit reply on my forum. Oddly, the post seems to go through anyway but I'd like to get rid of that big red error. Can someone please give me a step-by-step solution, like I'm a 5 year old.

Almost forgot, my host siteground is redoing their DNS or something, could it be related? The error just started today and the email they sent about the DNS was today as well (also pictured below).

Thanks for any help.

 

[Paul B]

Repair or truncate the xf_search_index table in the database.
You can use phpMyAdmin to do that.

If you truncate it, rebuild the search index in the XF ACP.

 

[thanks]

Repair or truncate the xf_search_index table in the database.
You can use phpMyAdmin to do that.

If you truncate it, rebuild the search index in the XF ACP.

Thanks for the quick reply. I just went into phpmyadmin and found the folder. How do I truncate? Thanks.

 

[thanks]

Tried rebuilding search index without the truncate and got this from within the xenforo admin panel:

 

[thanks]

Wait, you said "repair" the table in phpmyadmin. Don't think I did that yet so ignore the post above as it's just the error from rebuilding search through the ACP. So basically, how do I repair/truncate from the phpadmin screenshot above? Thanks.

 

[Paul B]

Neither of those screenshots are phpMyAdmin.

phpMyAdmin Repair and Optimize Database

In this easy to follow tutorial, you'll learn how to optimize and repair tables in MySQL databases

www.siteground.com

 

[thanks]

Following the tutorial, there's no "Repair" option next to "With selected"... bottom of the screenshot below. I clicked on Structure:

 

[Paul B]

Select the table from the list.



At the bottom choose repair.



Or just click Empty.



Then rebuild the index in the ACP.

 

[thanks]

I think it's fixed now, emptied the table. I went into xf_search instead of xf_search_index earlier, which could've been the problem. Thanks a lot for your help, Brogan.