[kevinnguyen]

everything was alright 1 hour ago (i've been using advcmps for months)
but tonight when i visit my site i got this error

Database error in vBulletin 3.0.3:

Invalid SQL: 
			SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
			thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
			
  		,thread.iconid AS threadiconid, iconpath AS threadiconpath 
  		, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision 
  		, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed  
  		, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
			FROM thread AS thread
			LEFT JOIN post AS post ON (post.postid = thread.firstpostid) 
  		LEFT JOIN icon USING (iconid) 
  		LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid) 
			LEFT JOIN user AS user ON (user.userid = post.userid)
			
			
  		
				LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
				LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
			 
  		 LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1') 
			LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
			WHERE forumid IN(11,22) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
			GROUP BY post.postid
			ORDER BY  postdateline DESC, attachmentid 
			LIMIT 3
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Thursday 27th of January 2005 08:40:25 PM
Script: http://dota-allstars.info/index.php
Referer: 
Username: FatalError
IP Address: 66.11.173.148

my forum is still fine
whats going? help plzzz....