Thread gone from index

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lowlight
    Senior Member
    • Mar 2001
    • 175

    Thread gone from index

    Our server's ISP had a power outage yesterday, and when it came back up, some tables needed repairing.

    After repairing the tables, everything seemed to work fine. However, there is ONE thread that is no longer showing up on the website. From what I can tell from user feedback, it's the only thread that is missing.

    I checked, and the posts are all there in the 'post' table. It just isn't being shown on the site.

    I have tried doing a 'Rebuild Thread Information' but it still isn't showing up.

    Any help would be appreciated. All the data is there in the database, I Just need to recover it.

    Thanks!
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    Is there an entry in the thread table for it?
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • lowlight
      Senior Member
      • Mar 2001
      • 175

      #3
      No, it is not in the thread table. its id is 556256. 556254 and 556257 are there, but not 556256

      So the posts are there, how do I get the thread back?

      Thanks

      Comment

      • lowlight
        Senior Member
        • Mar 2001
        • 175

        #4
        Could I just change the threadid manually in the posts table, to the new thread that was made?

        Comment

        • Trevor Hannant
          vBulletin Support
          • Aug 2002
          • 24325
          • 5.7.X

          #5
          Could try but there's no guarantee it would work (I've never tried it to be honest...)
          Vote for:

          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

          Comment

          • lowlight
            Senior Member
            • Mar 2001
            • 175

            #6
            Hi I tested it out with one of the posts, and it worked. Could you tell me the SQL query to do the rest at once?

            Original threadid is 556256 and the new one is 659190

            Thanks!

            Comment

            • Trevor Hannant
              vBulletin Support
              • Aug 2002
              • 24325
              • 5.7.X

              #7
              ** MAKE SURE YOU BACKUP YOUR DATABASE BEFORE RUNNING THIS **

              Try:

              Code:
              UPDATE PREFIX_post
              SET threadid = '659190'
              WHERE threadid = '556256'
              Change PREFIX_ to any prefix you have on your tables ore remove if you don't have one.
              Vote for:

              - Admin Settable Paid Subscription Reminder Timeframe (vB6)
              - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

              Comment

              • lowlight
                Senior Member
                • Mar 2001
                • 175

                #8
                OK the posts are in the thread, but since the new thread was only 7 pages, it thinks the 'last' page is page 7. Maybe update thread counter?

                Comment

                • lowlight
                  Senior Member
                  • Mar 2001
                  • 175

                  #9
                  OK that fixed the threads. Now we just lost a FORUM. The forumid references are all still there, in the threads table.

                  So do I do something similar here? Simply remake a new forum, and edit the table?

                  Comment

                  • lowlight
                    Senior Member
                    • Mar 2001
                    • 175

                    #10
                    I just made a new forum, changed the forumid to the old one, and rebuilt forum info.

                    Any idea on why this might be happening? We have a separate MySQL server, and have checked for hard drive issues, but nothing came up.

                    Comment

                    • lowlight
                      Senior Member
                      • Mar 2001
                      • 175

                      #11
                      No ideas?

                      Comment

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