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

XF 1.2 Updating Signature Permissions

Discussion in 'Troubleshooting and Problems' started by Joe Link, Apr 15, 2014.

  1. Joe Link

    Joe Link Well-Known Member

    I have disabled signature permissions for non-upgraded members, but imported users still have their signatures showing. How can I hide these signatures?
  2. borbole

    borbole Well-Known Member

    Go to your phpmyadmin and choose the database that you have installed your xenforo forum. Then at the SQL tab run this query:

    UPDATE xf_user_profile
    LEFT JOIN xf_user ON (xf_user.user_id = xf_user_profile.user_id)
    SET signature = ''
    WHERE xf_user.user_group_id = x;
    Replace x with the id of the group whose signatures you want to remove. And if you are using another prefix for your tables, replace xf_ with your custom prefix at the query above. Hope it helps.
  3. Martok

    Martok Well-Known Member

    Couldn't the OP just use the batch update users option in the ACP to remove signatures from the group?
    borbole likes this.
  4. borbole

    borbole Well-Known Member

    Of course. It just slipped my mind about that option. It is easier too. Thanks for the reminder.
    Martok likes this.
  5. Joe Link

    Joe Link Well-Known Member

    Thanks! I'm not comfortable with SQL queries just yet :)

Share This Page