Problem out of nowhere

[mholtum]

I woke up this morning to this error on my site:

Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , pollvoteid
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)
LEFT JOIN pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 1)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE open <> 10 AND thread.pollid != 0 AND visible = 1

AND thread.forumid IN(18)

AND deletionlog.primaryid IS NULL
ORDER BY poll.dateline DESC

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Monday 25th of July 2005 07:30:49 AM

and this one in my forums:

Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT imageid, images.title, filename, thumbname, extension, images.catid ,images.userid, images.username, images.title, images.description, images.dateline ,filesize, originalfilesize ,width, height, originalwidth, originalheight, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal, categories.title AS cattitle
FROM adv_gallery_images AS images
LEFT JOIN adv_gallery_categories AS categories USING (catid)
WHERE valid = 1
ORDER BY RAND()
LIMIT 5

mysql error: Can't open file: 'adv_gallery_images.MYI'. (errno: 144)

mysql error number: 1016

Date: Monday 25th of July 2005 07:31:31 AM
Script: http://www.ravensrealm.net/forum/
Referer:

what might have happened?

[ConqSoft]

Sounds like your mySQL ran out of disk space.

[mholtum]

Then on my other site portal:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , pollvoteid
FROM vb3_thread AS thread
INNER JOIN vb3_poll AS poll USING (pollid)
LEFT JOIN vb3_pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 1)
LEFT JOIN vb3_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE open <> 10 AND thread.pollid != 0 AND visible = 1 AND deletionlog.primaryid IS NULL AND forumid IN(62) ORDER BY poll.pollid DESC
LIMIT 1

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Monday 25th of July 2005 07:23:55 AM
Script: http://www.theflyfishingforum.com/
Referer:

and the forums are ok.

[ConqSoft]

"Got error 28 from table handler" usually means there wasn't enough disk space to perform an operation.

[mholtum]

interesting thanks. But what are the odds of two sites at the same time?

Are they on the same server? If so, then they should both be reporting that error. If you contact your host though they should be able to take care of the problem for you.

[mholtum]

Originally Posted by Brian

Are they on the same server? If so, then they should both be reporting that error. If you contact your host though they should be able to take care of the problem for you.

Yes they are on the same server. So I did contact my host and I am waiting to hear back. -edit-

He fixed it..