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

Comment