major vb Errors with New Post: Invalid SQL
 

hello, I'm reeeeealllly hoping someone can help me...

for what seems like no reason, all of a sudden I'm getting massive DB error on anything that has to do with making a post, editing a post, save changes....

as far as I know, no new hacks were added recently and there haven't been any changes to anything. So I have no idea where to start looking for a fix. The last hack I can remember adding was the OPT-OUT forums from New Posts by Andreas. But I never had a problem with that one int he past.

Any ideas where this is coming frrom? this is VERY bad as all new posts give me errors of one form or another.

Any help would be GREATLY appreciated!! this is bad bad bad!! :(


here's just a few examples of the errors.....
---------------------------------------------------------------------

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT postid, wordid,
CASE intitle
WHEN 0 THEN score
WHEN 1 THEN score + 5
WHEN 2 THEN score + 5 + 5
ELSE score
END AS score
FROM postindex
WHERE wordid IN (0,247,655);

MySQL Error : Can't open file: 'postindex.MYI' (errno: 145)
Error Number : 1016
Date : Sunday, February 19th 2006 @ 11:17:13 PM
Script : http://www.naestar.net/forums/newthread.php
Referrer : http://www.naestar.net/forums/newthr...ewthread&f=135
IP Address : ************
Username : *************
Classname : vb_database

================

Database error in vBulletin 3.5.3:

Invalid SQL:

REPLACE INTO postindex
(wordid, postid, score, intitle)
VALUES
(40, 22361, 1, 0), (1354, 22361, 1, 0);

MySQL Error : Can't open file: 'postindex.MYI' (errno: 145)
Error Number : 1016
Date : Sunday, February 19th 2006 @ 11:18:48 PM
Script : http://www.naestar.net/forums/newreply.php
Referrer : http://www.naestar.net/forums/showth...2351#post22351
IP Address : **************
Username : ****************
Classname : vb_database


=========
Database error in vBulletin 3.5.3:

Invalid SQL:
DELETE FROM postindex WHERE wordid IN (0,7527) AND postid = 22361;

MySQL Error : Can't open file: 'postindex.MYI' (errno: 145)
Error Number : 1016
Date : Sunday, February 19th 2006 @ 11:20:37 PM
Script : http://www.naestar.net/forums/editpost.php
Referrer : http://www.naestar.net/forums/editpost.php
IP Address : ****************
Username : ******************
Classname : vb_database

The index for your postindex table seems to be damaged.
Try to repair it several times.

I had a similar error to this once, and repairing the table did nothing.

I ended up dumping the entire DB, creating a new one, importing everything into it and that solved it.

My .2c - good luck.