[Forum] Pruning db error

[jtech77]

I noticed I have this error when I went to prune all awaiting mod
threads... what do I do to fix it? Thanks,

Database error in vBulletin 4.2.0:

Invalid SQL:

DELETE searchgroup, searchgroup_text

FROM searchgroup AS searchgroup JOIN

searchgroup_text AS searchgroup_text ON

searchgroup.searchgroupid = searchgroup_text.searchgroupid

WHERE searchgroup.contenttypeid = 2 AND

searchgroup.groupid = 29557;

MySQL Error : Incorrect key file for table
'./pennyauc_forum/searchgroup_text.MYI'; try to repair it

Error Number : 126

Request Date : Thursday, January 31st 2013 @ 08:05:18 PM

Error Date : Thursday, January 31st 2013 @ 08:05:19 PM

[Lynne]

Please do as the error says and repair the searchgroup_text table.

[Hartmut]

AdminCP -> Maintenance -> Repair / Optimize Tables. Select all tables and run the service.