SQL Error 1030 (Error 28 from table handler)

[Wachtmeister]

Hello,

a get following error since today, when calling my portal.





Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle

,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM vb3_thread AS thread
LEFT JOIN vb3_forum AS forum USING (forumid)
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb3_icon USING (iconid)
LEFT JOIN vb3_user AS user ON (user.userid = post.userid)



LEFT JOIN vb3_avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb3_customavatar as customavatar ON (customavatar.userid = user.userid)

LEFT JOIN vb3_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
LEFT JOIN vb3_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(1321,1299,1288,1285,1279,1271,1269,1261)

GROUP BY post.postid
ORDER BY thread.dateline DESC
LIMIT 8;

MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Thursday, November 10th 2005 @ 02:33:29 PM
Script : http://www.webgurus.de/
Referrer :
IP Address : 85.178.135.1
Username : admin
Classname : vb_database


Can someone please help me out?

Thanks, Wachtmeister

[Wachtmeister]

Well, it seems, that my server had a problem, that is now gone... Strange. It had nothing to do with a vbadvanced malfunction, so ignore this ;) It's running fine again.