how to rebuild phrase table

[spankaveli]

i was attempting to correct an issue with my vba cpms and somehow i inadvertently crashed my phrases

every time i go to "newposts" or some other thigns, i get this:

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT text, languageid, special
FROM bayouphrase AS phrase
LEFT JOIN bayouphrasetype USING (fieldname)
WHERE phrase.fieldname = 'frontredirect'
AND varname = 'search' AND languageid IN (-1, 0, 1);

MySQL Error : Table './b4y0u_forum/bayouphrase' is marked as crashed and should be repaired
Error Number : 145
Request Date : Wednesday, May 7th 2008 @ 03:38:20 PM
Error Date : Wednesday, May 7th 2008 @ 03:38:20 PM
Script : http://www.bayoushooter.com/forums/search.php?do=getnew
Referrer : http://www.bayoushooter.com/forums/
IP Address : 209.124.224.37
Username : spanky
Classname : vB_Database
MySQL Version : 5.0.45-community

[Dismounted]

Admin CP > Maintenance

Make sure you run it through a few times.

[Marco van Herwaarden]

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:
Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue
If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.