Announcement

Collapse
No announcement yet.

MY DB just got screwed over BIG

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

  • MY DB just got screwed over BIG

    Code:
    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: 
    SELECT
    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
    Referer:
    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

    Comment


    • #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.

      Comment


      • #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.

        Comment

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