HI,

I keep getting this intermittant database error.

Im not sure if the upgrade is a co-incidence

Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT post.dateline, post.pagetext AS message, post.allowsmilie, post.postid,
thread.threadid, thread.title, thread.prefixid, post.attach,
forum.forumid,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM post AS post
JOIN thread AS thread ON (thread.threadid = post.threadid)
JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN user AS user ON (post.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND thread.forumid IN(231,142,148,194,222,198,124,217,225,228,110,100,101,147,219,201,229,111,141,112,117,177 ,176,118,138,106,107,116,135,122,134,133,215,126,207,104,125,209,197,108,152,120,175,230,2 02,196,109,216,211,223,150,203,181,179,187,210,114,189,190,204,165,227,224,154,186,115,212 ,213,214,137,174,136,226,191,151,221,113,188,178,185,149,129,67,182)
AND thread.visible = 1
AND post.visible = 1
AND thread.open <> 10
AND post.dateline > 1261181821


ORDER BY post.dateline DESC
LIMIT 0,5;

MySQL Error : Incorrect key file for table '/tmp/#sql_76ef_0.MYI'; try to repair it
Error Number : 126
Request Date : Monday, January 18th 2010 @ 12:17:01 AM
Error Date : Monday, January 18th 2010 @ 12:17:05 AM
Script : http://www.soapchat.net/forum.php
Referrer : http://www.soapchat.net/showthread.p...rt-error/page3
Username : Pamela
Classname : vB_Database
MySQL Version : 5.0.82sp1