Index page went dead

[Itworx4me]

Hello all,

Any one experienced this error on the front page:

Invalid SQL:
SELECT

thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread as thread
LEFT JOIN icon USING (iconid)
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
WHERE open <> '10' AND thread.visible = 1 AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 3

mysql error: Got error 28 from table handler

mysql error number: 1030


I have not added any new content to the forum and all of a sudden I am getting this error on the vbavanced index page. The forum works still. I checked all the tables and there isn't anything wrong with the tables. Not sure what is going on but if someone could help out on the error would be appreciated.

Thanks,
Itworx4me

[Brian]

That error means that one of your tables is corrupt. You should try repairing your thread, icon, forum, post, deletionlog, and subscribethread tables.

[Our Sponsors]

[Itworx4me]

Thanks Brian. I did all those things before writing this post. It ended up being the mysql server was down. I appreciate your post and will use it for future errors.

Thanks,
Itworx4me