PDA


View Full Version : VB: 3.0.3 - Database Error


xtrematrix
03-17-2005, 03:37 PM
I am getting this error:


Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , pollvoteid
FROM thread AS thread
INNER JOIN poll AS poll 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 deletionlog.primaryid IS NULL AND forumid IN(76) ORDER BY poll.pollid DESC
LIMIT 1

mysql error: Can't create/write to file '/var/tmp/#sql_190_0.MYI' (Errcode: 28)

mysql error number: 1



I have not changed anything for a while now. I dont know what could have caused this. Does anyone have any ideas?

My forums still work, just not the vBadvanced.

Brian
03-17-2005, 03:44 PM
Error code 28: No space left on device

Sounds like you're out of space on your server.

xtrematrix
03-17-2005, 03:44 PM
I just disabled the poll option and now i am getting a different error. I have no clue what to try now :-/


Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT IF(votenum >= 2, votenum, 0) AS votenum, IF(votenum >= 2 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


, 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 deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN(60) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
GROUP BY post.postid
ORDER BY postdateline DESC
LIMIT 20
mysql error: Can't create/write to file '/var/tmp/#sql_190_0.MYI' (Errcode: 28)

mysql error number: 1

xtrematrix
03-17-2005, 03:47 PM
Thanks Brian... I will see if this is something on my end :)