PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.0.X (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-0-x/)
-   -   Problem out of nowhere (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-0-x/118822-problem-out-nowhere.html)

mholtum July 25th, 2005 09:32 AM

Problem out of nowhere
 
I woke up this morning to this error on my site:
Quote:

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:
Quote:

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 July 25th, 2005 09:34 AM

Re: Problem out of nowhere
 
Sounds like your mySQL ran out of disk space.

mholtum July 25th, 2005 09:35 AM

Re: Problem out of nowhere
 
Then on my other site portal:
Quote:

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 July 25th, 2005 09:36 AM

Re: Problem out of nowhere
 
"Got error 28 from table handler" usually means there wasn't enough disk space to perform an operation.

mholtum July 25th, 2005 09:37 AM

Re: Problem out of nowhere
 
interesting thanks. But what are the odds of two sites at the same time?

Brian July 25th, 2005 09:56 AM

Re: Problem out of nowhere
 
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 July 25th, 2005 09:59 AM

Re: Problem out of nowhere
 
Quote:

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..


All times are GMT -5. The time now is 06:46 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97