XF 1 Tip Rebuild user post counts (query)

[ENXF NET]

LQD submitted a new resource:

Rebuild user post counts (query) - A database query to rebuild all user post counts.

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 xf_thread AS thread ON (thread.thread_id = post.thread_id)
    WHERE post.user_id = user.user_id
    AND post.message_state = 'visible' AND thread.discussion_state = 'visible'
    GROUP BY post.user_id
);

If you have forums you wish to exclude from...

Read more about this resource...