XF 1.4 Notable Members - Most Resources

[iguanairs]

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?

 

[Jake Bunce]

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]

That worked. I was only off by 658. lol