Announcement

Collapse
No announcement yet.

Should I roll back....error

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

  • [Forum] Should I roll back....error

    Hi,

    I'm trying to fine an anwser to this issue but since the upgrade I have an intermittant databse error.

    I'm not sure if its a co-incidence or connected to 4.0

    This happens when I first arrive on the forum. If I refresh its ok:

    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,1 38,106,107,116,135,122,134,133,215,126,207,104,125 ,209,197,108,152,120,175,230,202,196,109,216,211,2 23,150,203,181,179,187,210,114,189,190,204,165,227 ,224,154,186,115,212,213,214,137,174,136,226,191,1 51,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

  • #2
    Sounds like a server setting needs to be increased. I suggest asking your web hosting provider to fix this problem.

    Comment


    • #3
      Thank you. What makes you think its a server setting?

      Comment


      • #4
        Originally posted by PamelaE View Post
        Thank you. What makes you think its a server setting?

        MySQL Error : Incorrect key file for table '/tmp/#sql_76ef_0.MYI'; try to repair it

        according to the last line repairing that table to fix the issue

        Comment


        • #5
          Originally posted by PamelaE View Post
          Thank you. What makes you think its a server setting?
          Just enter this into Google.

          Incorrect key file for table '/tmp/

          You'll see others have had this problem and the solution is to increase memory to certain items in the server software.

          Comment

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