SQL data base error

[Lee G]

My server host told me to optimise my tables and run a repair of the tables, now Im getting the following error come through

Database error in vBulletin 3.8.1:

Invalid SQL:

REPLACE INTO postindex
(wordid, postid, score, intitle)
VALUES
(100, 9, 1, 0), (101, 9, 1, 0), (1, 9, 1, 0), (102, 9, 1, 0), (99, 9, 1, 0);

MySQL Error : Table 'postindex' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Request Date : Wednesday, October 14th 2009 @ 12:08:16 PM
Error Date : Wednesday, October 14th 2009 @ 12:08:16 PM
Script : http://www.thespainforum.com/admincp/misc.php?do=buildpostindex
Referrer : http://www.thespainforum.com/admincp/misc.php?do=chooser
IP Address : ########
Username : #####
Classname : vB_Database
MySQL Version : 4.1.22-standard-log

Is there anyway of sorting this out, Im at my wits end and as you can imagine, just a bit stressed

[Lee G]

When I run repair optimise from the admin panel, I get the following error

postindex Check Warning: Table is marked as crashed and last repair failed postindex Check Warning: 3 clients are using or haven't closed the table properly postindex Check Error: Found 1537 keys of 3221228 postindex Check Error: Corrupt postindex

[Lynne]

Take a look at this - 3 ways to repair a database See if another method will help in repairing the table.