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

XF 1.1 User ban : how to delete name

Discussion in 'XenForo Questions and Support' started by kankan, Feb 16, 2015.

  1. kankan

    kankan Active Member

    Hello

    I have deleted a user on our forum. (XF 1.1.3)
    But his name (not active) still appears on postbit.
    Please can you tell me which SQL request to parse in order to replace his name by another ?
    Thank you for your support.
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Code:
    UPDATE xf_post
    SET username = 'new username'
    WHERE username = 'old username'
    AND user_id = 0;
    
    UPDATE xf_thread
    SET username = 'new username'
    WHERE username = 'old username'
    AND user_id = 0;
    
     
    kankan likes this.
  3. kankan

    kankan Active Member

    Thank you Jake.
     
  4. kankan

    kankan Active Member

    Re jake
    working but had to remove AND user_id=0;
     
  5. kankan

    kankan Active Member

    But the name on the Postbit under Avatar remains :(
    don't know how to remove it.
     

Share This Page