Announcement

Collapse
No announcement yet.

Database error

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

  • [Suite] Database error

    HI,

    I keep getting this intermittant database error.

    Im not sure if the upgrade is a co-incidence

    Database error in vBulletin 4.0.1:

    Invalid SQL:

    SELECT post.dateline, post.pagetext AS message, post.allowsmilie, post.postid,
    thread.threadid, thread.title, thread.prefixid, post.attach,
    forum.forumid,
    user.*
    ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
    FROM post AS post
    JOIN thread AS thread ON (thread.threadid = post.threadid)
    JOIN forum AS forum ON(forum.forumid = thread.forumid)
    LEFT JOIN user AS user ON (post.userid = user.userid)
    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
    WHERE 1=1
    AND thread.forumid IN(231,142,148,194,222,198,124,217,225,228,110,100,101,147,219,201,229,111,141,112,117,177 ,176,118,138,106,107,116,135,122,134,133,215,126,207,104,125,209,197,108,152,120,175,230,2 02,196,109,216,211,223,150,203,181,179,187,210,114,189,190,204,165,227,224,154,186,115,212 ,213,214,137,174,136,226,191,151,221,113,188,178,185,149,129,67,182)
    AND thread.visible = 1
    AND post.visible = 1
    AND thread.open <> 10
    AND post.dateline > 1261181821


    ORDER BY post.dateline DESC
    LIMIT 0,5;

    MySQL Error : Incorrect key file for table '/tmp/#sql_76ef_0.MYI'; try to repair it
    Error Number : 126
    Request Date : Monday, January 18th 2010 @ 12:17:01 AM
    Error Date : Monday, January 18th 2010 @ 12:17:05 AM
    Script : http://www.soapchat.net/forum.php
    Referrer : http://www.soapchat.net/showthread.p...rt-error/page3
    Username : Pamela
    Classname : vB_Database
    MySQL Version : 5.0.82sp1
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X