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

Reset signatures with help of SQL query?

Discussion in 'XenForo Questions and Support' started by fredrikse, Aug 3, 2012.

  1. fredrikse

    fredrikse Active Member


    I would like to reset the signature field in xenForo after migration from vB is completed. What would the SQL query for that be?
  2. borbole

    borbole Well-Known Member

    By resetting you mean to truncate/delete all signatures for everyone? If so run this query at the SQL box in phpmyadmin

    UPDATE xf_user_profile
    SET signature = '';
    If you are using another prefix for your tables, replace xf_ with your custom prefix at the queries above. Hope it helps.
    dono and Jake Bunce like this.
  3. fredrikse

    fredrikse Active Member

    Thanks a lot!
    borbole likes this.
  4. borbole

    borbole Well-Known Member

    You are welcome :)
  5. Toxic

    Toxic Member

    is this possible to reset just one User Group - say the registered users?
  6. borbole

    borbole Well-Known Member

    Yes, I replied to your other post.

Share This Page