No announcement yet.

MY DB just got screwed over BIG

  • Filter
  • Time
  • Show
Clear All
new posts

  • MY DB just got screwed over BIG

    There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
    We apologise for any inconvenience.
    Database error in vBulletin: Invalid SQL: 
    session.userid AS sessionuserid,
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    FROM post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    LEFT JOIN session ON (session.userid = user.userid
                                                AND session.userid > 0
                                                AND session.lastactivity>1003678972)
    WHERE post.postid IN (0,146521,146526,146580)
    ORDER BY dateline 
    mysql error: Got error -1 from table handler
    mysql error number: 1030
    Date: Sunday 21st of October 2001 10:57:52 AM
    Script: /forum/showthread.php?postid=146580&t=7307
    Big site - over 150,000 posts... need to get back up and running soon. Please help - I have NO IDEA what this means.

  • #2
    note: this comes up when you try to go into a thread


    • #3
      I am not sure what
      mysql error: Got error -1 from table handler
      mysql error number: 1030
      means but it is possible that your database crashed.

      You might want to use repair.php that is included in extra folder.

      if it doesn't work, restore your recent backup.


      • #4
        -1 means the database doesn't know what went wrong.

        Klisis is right - grab repair.php from the 'extras' directory of your vBulletin zip file and upload it to your main forums directory. Run it in a browser and follow the on-screen instructions.


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