Weird database errors, help needed

[Chruser]

This happens upon loading only one, specific forum category on the board:

Database error in vBulletin 2.2.6:
Invalid SQL:
SELECT

thread.threadid FROM thread
LEFT JOIN user ON (thread.postuserid = user.userid)
WHERE thread.forumid = 272
AND thread.sticky=0

AND thread.visible=1
AND thread.lastpost >= 1062093933 AND sticky=0

ORDER BY sticky DESC, thread.lastpost DESC
LIMIT 0,25
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Saturday 27th of September 2003 01:05:33 PM
Script: http://www.zelaron.com/forums/forums...s=&forumid=272
Referer:


And I encounter this message in the admin panel itself:

Database error in vBulletin Control Panel 2.2.6:
Invalid SQL: SELECT count(*) AS count FROM thread WHERE dateline >= 1064638800
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Saturday 27th of September 2003 01:03:35 PM
Script: http://www.zelaron.com/forums/forums...s=&action=home
Referer: http://www.zelaron.com/forums/admin/



Any help would be appreciated. :/

[Matthew Gordon]

I forget what error 127 actually is, but try running repair.php.

[Chruser]

Hmm, will repair.php from the 2.3.2 release work although I'm on 2.2.6? Besides, I'm encountering the error in a lot of random places, which isn't a good thing. Actually, go check it out for yourselves. A lot of threads seem to generate errors randomly. Oh, and view new posts doesn't work either:

http://www.zelaron.com/forums

[poolking]

Do you still have the 2.2.6 zip file? If so it is in the extras directory.

[Chruser]

No, I don't. Ugh, this isn't good.

[Chruser]

zelaron.threadcheckerrorRecord at pos: 2280132 is not remove-markedzelaron.threadcheckerrorrecord delete-link-chain corruptedzelaron.threadcheckerrorCorruptRepairing table threadzelaron.threadrepairinfoWrong bytesec: 32-65-100 at 2280132; Skipped




Seems to work again, thanks.

[Artaxerxes]

How long does it take to run the repair.php file? Just so I know how long my our forum will be down?

Thanks,

[Scott MacVicar]

depends on the size of the forum and server specifications.

I know a large 5GB database can take 20 minutes to optimize / check all tables.

vB.com in roughly 5 minutes

smaller board in seconds.

[Artaxerxes]

Cool, thanks for the info.

[Artaxerxes]

AWESOME ,

Thanks everybody for your help!!