Thread error - sorry

Discussion in 'Middle East - General' started by jimnyc, Sep 11, 2003.

  1. jimnyc
    Offline

    jimnyc ...

    Joined:
    Aug 28, 2003
    Messages:
    10,113
    Thanks Received:
    244
    Trophy Points:
    83
    Location:
    New York
    Ratings:
    +246
    Database became corrupted that we were all just discussing, I am currently working to retrieve it.
     
  2. NightTrain
    Offline

    NightTrain VIP Member

    Joined:
    Aug 29, 2003
    Messages:
    1,425
    Thanks Received:
    87
    Trophy Points:
    83
    Location:
    Wasilla, Alaska
    Ratings:
    +87
    I sure hope you can resurrect that thread, Jim! I thought about that last night after I posted & was going save a copy of the whole thread just because.
     
  3. spillmind
    Offline

    spillmind Member

    Joined:
    Sep 1, 2003
    Messages:
    780
    Thanks Received:
    13
    Trophy Points:
    16
    Location:
    Palo Alto, Ca.
    Ratings:
    +13
    i saved copies.

    i am more of a loser than all y'all!
     
  4. jimnyc
    Offline

    jimnyc ...

    Joined:
    Aug 28, 2003
    Messages:
    10,113
    Thanks Received:
    244
    Trophy Points:
    83
    Location:
    New York
    Ratings:
    +246
    I do have a backup, but it's 24 hours old.

    The SQL request crashed while the thread in question was open. The repair utility flushes out all data that is not recognizable. Since the thread was opened, it repairs everything else and discards that. It looks like it is gone.

    I'm entering a support ticket to see if anything can be done to revive it.
     
  5. jimnyc
    Offline

    jimnyc ...

    Joined:
    Aug 28, 2003
    Messages:
    10,113
    Thanks Received:
    244
    Trophy Points:
    83
    Location:
    New York
    Ratings:
    +246
    Unfortunately, it's probably useless to me as it won't be in sql format. If you did in fact save it all, it would be nice to have it even reposted in text format.

    If so, you may need to do so over several posts as there is a 15,000 character limitation.
     
  6. NightTrain
    Offline

    NightTrain VIP Member

    Joined:
    Aug 29, 2003
    Messages:
    1,425
    Thanks Received:
    87
    Trophy Points:
    83
    Location:
    Wasilla, Alaska
    Ratings:
    +87
    Good job, Spill.

    That would be excellent.. I hate redoing things.
     
  7. jimnyc
    Offline

    jimnyc ...

    Joined:
    Aug 28, 2003
    Messages:
    10,113
    Thanks Received:
    244
    Trophy Points:
    83
    Location:
    New York
    Ratings:
    +246
    Here's the question I sent to support, I'll update you all as to what they say. I'm confident they'll say the thread is history, but it can't hurt to ask.
    ----------------------------------------------------

    While thread was open by several users, the following error ocurred:

    Database error in vBulletin 2.3.2:

    Invalid SQL:
    SELECT

    thread.threadid
    FROM thread
    WHERE thread.forumid = 15
    AND thread.sticky=0
    AND thread.visible=1
    AND sticky=0

    ORDER BY sticky DESC, lastpost DESC
    LIMIT 0,25
    mysql error: Got error 127 from table handler

    mysql error number: 1030



    I was able to use MySql Front and ran a repair. The forum is now accessible once again, minus the thread in question.

    Although I have a backup of all my databases as of 24 hours ago, am I assuming correctly that everything entered in that thread since is now gone forever?

    Lastly, what can be done to prevent thread loss in the future? Other than backing up after every post of course.
     
  8. janeeng
    Online

    janeeng Guest

    Ratings:
    +0
    Damn, and I never got to see the reply from limp dick! Hey spill you rubbing your ball? hahahahahahhaahhaahha!
     

Share This Page