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

Thread move query

Discussion in 'XenForo Questions and Support' started by Lee, Jun 17, 2013.

  1. Lee

    Lee Well-Known Member

    What I am looking to do is, via phpMyAdmin - select all threads, regardless of their current location and move them to node_id = x.

    Anybody able to provide me with a query to do this? So I don't have to go in and move all threads manually.


    Cheers,
    Lee
     
  2. MattW

    MattW Well-Known Member

  3. Brogan

    Brogan XenForo Moderator Staff Member

    Code:
    UPDATE xf_thread
    SET node_id = x
     
    Lee, LPH, MattW and 1 other person like this.
  4. Lee

    Lee Well-Known Member

    Not quite, but looks useful anyway - thanks for the link.

    Thanks Brogan, that did the trick. Is there a way to rebuild user posts counts, as I have moved threads into a section that no longer counts against the post count.
     
  5. MattW

    MattW Well-Known Member

    caches.PNG
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

  7. MattW

    MattW Well-Known Member

    Lee likes this.
  8. Lee

    Lee Well-Known Member

  9. MattW

    MattW Well-Known Member

    That's my education for today then ;)
     
    Lee likes this.

Share This Page