Recreating a deleted thread number?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • novabandit
    New Member
    • Feb 2006
    • 17

    Recreating a deleted thread number?

    I have a thread that was heavily linked to on my forums that was hard deleted (long story).

    Now all those links go to the "invalid thread" page.

    I was able to (from a DB backup restored onto a test forum) get the contents of the main post, which is the only one I care about, but is it possible to create a new thread in the old thread's location (thread number?)

    This is reeeeeally important to me... as this thread brought more traffic to my site than nearly anything else!
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    Do you have a copy of that thread in a backup? You may be able to restore it from there although I would test this out on a copy of your site beforehand.

    Also, take a look over at www.vbulletin.org to see if there are any tools to help with this.
    Vote for:

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

    Comment

    • novabandit
      New Member
      • Feb 2006
      • 17

      #3
      I do have an entire backup of the site running on my test site.

      Comment

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

        #4
        Can't remember exactly which tables you need to take information out of to restore a thread. Have you checked vb.org for any tools which can do this?
        Vote for:

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

        Comment

        • Lats
          Senior Member
          • Mar 2002
          • 3671

          #5
          Try this, restore the backup to a different database and using the operations tab in phpmyadmin, rename the thread and post tables to something with a number on the end (post7 and thread7) then copy those 2 tables to the live database.
          Run the following queries changing 777 to the threadid of the deleted thread.
          Code:
          INSERT INTO
             thread
          (SELECT
             *
          FROM
             thread7
          WHERE
             threadid = 777)
          Code:
          INSERT INTO
             post
          (SELECT
             *
          FROM
             post7
          WHERE
             threadid = 777)
          Lats...

          Comment

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

            #6
            And there's the very man...
            Vote for:

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

            Comment

            • siliconfinance
              Senior Member
              • Mar 2007
              • 112
              • 3.5.x

              #7
              I know I am bumping an old thread, but I was linked here as a potential solution to my problem. My question relates to attachments. How would we ensure that the attachments also get restored along with the thread? Or do the attachments still exist even after a thread is deleted such that restoring the thread, restores the references to those attachments, and that is all that is needed?

              For the record, my attachments are stored in the file system.

              Comment

              • NIKU-DR
                Member
                • Jul 2004
                • 30
                • 3.5.x

                #8
                Try this, restore the backup to a different database and using the operations tab in phpmyadmin, go to database_name rename the thread and post tables to something with a number on the end (10post and 10thread) then copy those 2 tables to the live database

                On database_live go to Sql

                Code:
                INSERT IGNORE
                  INTO thread
                SELECT *
                  FROM 10thread
                     ;
                Code:
                INSERT IGNORE
                  INTO post
                SELECT *
                  FROM 10post
                     ;

                Comment

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