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

XF 1.5 Signature not Displaying for Registered

Discussion in 'Troubleshooting and Problems' started by akhilaniyan, Feb 11, 2016.

  1. akhilaniyan

    akhilaniyan Active Member

    Hello!

    Just now I noticed that, the signature is not visible to the forum members. But, I can see the signatures! Guest can also see the signatures.

    Looks like some permission issues. I tried, but I'm unable to find the solution!

    Please help me to fix this.

    Thanks.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    akhilaniyan likes this.
  3. akhilaniyan

    akhilaniyan Active Member

    "Show people's signatures with their messages" was the issue...How to make "checked" for all users by default?
     
  4. akhilaniyan

    akhilaniyan Active Member

    Ya, I got the option from users And Registration options!
     
  5. akhilaniyan

    akhilaniyan Active Member

    But, thank you so much Brogan for reminding me the options...
     
  6. akhilaniyan

    akhilaniyan Active Member

  7. Brogan

    Brogan XenForo Moderator Staff Member

    Yes, it's possible with a query but I don't think you should be changing member settings/preferences without their explicit permission.
     
    Tracy Perry and akhilaniyan like this.
  8. wang

    wang Well-Known Member

    That option is checked by default. So if a member has unchecked it, they must have their reasons for doing so. And I think the same like @Brogan, you should not be changing member settings/preferences without their explicit permission. It might not sit well with them and it can result in them leaving your forum.

    That said, you can accomplish what you asked by excecuting this sql query.

    Code:
    UPDATE xf_user_option SET content_show_signature = 1;
    I think that being cautious will be the best approach towards this. Excecute first this sql query

    Code:
    SELECT user.username, signature.content_show_signature
    FROM xf_user AS user
    LEFT JOIN xf_user_option AS signature
    ON (user.user_id = signature.user_id)
    WHERE signature.content_show_signature = 1;
    Then make a note if you have important members that have disabled that field, and you can excecute this sql query instead to exclude them.

    Code:
    UPDATE xf_user_option SET content_show_signature = 1 WHERE user_id NOT IN (x,y);
    You must replace x and y values in the query with the id 's of the users who will not be affected by the query.
     
    akhilaniyan likes this.
  9. akhilaniyan

    akhilaniyan Active Member

    Thank you so much Wang! It worked perfectly!
     
    wang likes this.
  10. wang

    wang Well-Known Member

    You are most welcome sir :)
     
    akhilaniyan likes this.

Share This Page