[xenForo Tips/Guide] Rebuild user post counts (query)

A database query to rebuild all user post counts.

  1. XenForo Rocks
    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.

    Code:
    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.