XF 2.2 AbstractStatement MySQL error

thanks

Member
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).

sqlwckxl.jpg


035c35bc-f675-4e26-8vcj24.jpeg




Thanks for any help.
 

Brogan

XenForo moderator
Staff member
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

Member
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.
 

thanks

Member
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.
 
Top