How to automatically fix mysql database error?

[postcd]

From time to time i got issue with this table. It happend again now when tried to delete some topic. One topic was deleted but second one happens this error:

Database error in vBulletin 4.1.10:

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 = 8220;

MySQL Error : Table './mydb_vb/searchgroup_text' is marked as crashed and should be repaired
Error Number : 145

I know there is myisamchk or mysqlcheck or such tools, but they dont works to fix tables , i already tried its fix opperators, but it did not repaired. Only when i use some repair command, but then it somehow repair all tables not only those crashed.

Please idea on how to automatically detect error and auto fix such erroneous table? im under my own linux server.

[RichieBoy67]

You can go into either vbulletin admincp or phpadmin to choose the table you want to repair. Just choose the search table and repair it. Or use something like this in ssh -

repair table searchgroup_text;