This will recalculate and update the post counts for all users at once. This is a large query that may take a while to finish.
UPDATE xf_user AS user SET message_count = ( SELECT COUNT(*) FROM xf_post AS post LEFT JOIN...
You do not have permission to view the full content of this resource. Log in or register now.