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

XF 1.4 Notable Members - Most Resources

Discussion in 'Troubleshooting and Problems' started by iguanairs, Jan 20, 2015.

  1. iguanairs

    iguanairs Member

    I must be missing a setting somewhere because I have several hundred resources on my website but it only states that I have "5" under the Notable Members - Most Resources tab within the members section. I rebuilt all of the caches and it shows all of my resources within my profile as well. Is there a setting I am missing?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Those counts are incremented when you post a resource. If for some reason the count is wrong then you can run this query on your database to correct it:

    UPDATE xf_user u
    SET u.resource_count = (
        SELECT COUNT(*)
        FROM xf_resource r
        WHERE r.user_id = u.user_id
        AND r.resource_state = 'visible'
    iguanairs likes this.
  3. iguanairs

    iguanairs Member

    That worked. I was only off by 658. lol

Share This Page