No announcement yet.

Database Error again

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error again

    I have yet another database error. Is it my host again?

    Database error in vBulletin 3.0.6:

    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

    , 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 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(4) AND thread.visible = 1 AND != 10 AND deletionlog.primaryid IS NULL
    GROUP BY post.postid
    ORDER BY postdateline DESC
    LIMIT 6
    mysql error: Got error 28 from table handler

    mysql error number: 1030

    Date: Friday 29th of July 2005 03:01:54 PM
    Username: bmroyer
    IP Address:

  • #2
    Error code 28: No space left on device

    One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

    Here is an explanation of the error on the MySQL site:
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.