No announcement yet.

Database Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error

    Database error in vBulletin 3.5.1:

    Invalid SQL:

    SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
    thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie

    ,thread.iconid AS threadiconid, iconpath AS threadiconpath
    , avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
    , NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
    FROM thread AS thread
    LEFT JOIN post AS post ON (post.postid = thread.firstpostid)

    LEFT JOIN post_parsed AS post_parsed ON (post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)

    LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid)
    LEFT JOIN user AS user ON (user.userid = post.userid)

    LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
    LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)

    LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
    WHERE thread.threadid IN(725,719,716,702,661,650,641,632)

    GROUP BY post.postid
    ORDER BY sticky DESC,thread.dateline DESC
    LIMIT 8;

    MySQL Error : Got error 28 from storage engine
    Error Number : 1030
    Date : Monday, August 7th 2006 @ 08:26:10 PM
    Script :
    Referrer :
    IP Address :
    Username : bmroyer
    Classname : vb_database

  • #2
    MySQL Error : Got error 28 from table handler

    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.