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

XF 1.2 Merging existing user with deleted user?

Discussion in 'XenForo Questions and Support' started by Moddis, Feb 8, 2014.

  1. Moddis

    Moddis Active Member

    I know there is an option to merge users but is it possible to merge an existing user with a deleted user? Basically, looking to merge posts of a specific "Guest" member to a real active member.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    That's not possible.
     
  3. Moddis

    Moddis Active Member

    Ok I guess I can try manually changing in the db:

    UPDATE xf_post SET username = REPLACE(username,'deleted_user','activeuser');

    Hopefully there is nothing else that needs to be updated anywhere to keep everything working correctly.
     
  4. Moddis

    Moddis Active Member

    Opps, almost forgot about the user id. Thanks!
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  6. Moddis

    Moddis Active Member

    Thanks, this looks good but dont you(or should you) also have to also chnage the username colum to the new username as well? Those just seem to change the username id.
     
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Moddis likes this.
  8. Moddis

    Moddis Active Member

    Cool!
     

Share This Page