1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Move all discussions in one node to another

Discussion in 'XenForo Questions and Support' started by Douglas Taylor, Sep 7, 2012.

  1. Douglas Taylor

    Douglas Taylor Active Member

    Is there a method for doing this? I need to delete a node, but move the threads to another node.
  2. MagnusB

    MagnusB Well-Known Member

    You have to move the threads manually before doing anything, you can do so by going in to the forum, click on the 0 selected threads, then check off select all, then go to the next page (don't worry, xF remembers what threads you selected) and do the same (though this time it should say x selected threads). Once you done that for all pages in the forum, just use the inline mod to move all the threads at once.
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query on your database:

    UPDATE xf_thread
    SET node_id = 5
    WHERE node_id = 2
    5 being the destination, 2 being the source.

    Then rebuild your forum info:

    Admin CP -> Tools -> Rebuild Caches
    Chris D likes this.
  4. Douglas Taylor

    Douglas Taylor Active Member

    Worked like a charm.

    Thank you gentlemen!
  5. snoopy5

    snoopy5 Well-Known Member

    Do you mean with this, typing it in phpmyadmin?

    If yes, where exactly?
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    In the SQL tab in phpmyadmin.
    snoopy5 likes this.
  7. zeropaid

    zeropaid Member

    Is this still the only way? I have several dead nodes and I want to move all the messages to the parent node. Why not have an option in the delete node popup to move all messages to the parent node?
  8. Mike

    Mike XenForo Developer Staff Member

    It should be done with the batch update threads tool.

Share This Page