Announcement

Collapse
No announcement yet.

Database error in vBulletin 3.8.0:

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error in vBulletin 3.8.0:

    Database error in vBulletin 3.8.0:

    Invalid SQL:

    SELECT
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    post.pagetext AS preview,
    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
    thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
    thread.prefixid, thread.taglist, hiddencount, deletedcount
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
    , threadread.readtime AS threadread
    , threadredirect.expires
    , hasannuser.displaygroupid AS hasanndisplaygid, hasannuser.usergroupid AS hasannusergid, huseyinuser.displaygroupid AS huseyindisplaygid, huseyinuser.usergroupid AS huseyinusergid, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
    LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

    LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
    LEFT JOIN user AS hasannuser ON (thread.lastposter = hasannuser.username)
    LEFT JOIN user AS huseyinuser ON (thread.postuserid = huseyinuser.userid)LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
    WHERE thread.threadid IN (0,1658,12764,12369,2847,12491,12311,12209,11604,11564,11563,11200,10797,10127,9411,5352,4 996,4104,4565,2630,3379,20,1034,3831,11638,12736) GROUP BY thread.threadid
    ORDER BY sticky DESC, lastpost DESC;

    MySQL Error : Got error 28 from storage engine
    Error Number : 1030
    Request Date : Sunday, January 11th 2009 @ 05:14:37 AM
    Error Date : Sunday, January 11th 2009 @ 05:14:37 AM
    Script : http://www.world-own.com/f2/
    Referrer : http://www.world-own.com/
    IP Address : 79.**.***.**
    Username : BlacKSouL
    Classname : vB_Database
    MySQL Version : 5.0.67-community

    /////////////////////////////////////////////////////////////////////////////////////


    what is error i cant open 1 section : http://www.world-own.com/f2/
    SHeRY

  • #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 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.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.6.3 Demo
    AdminAmmo - My Cloud Demo

    Comment

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