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

Rebuild user post counts (query)

A database query to rebuild all user post counts.

  1. Jake Bunce
    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 xf_thread AS thread ON (thread.thread_id = post.thread_id)
    	WHERE post.user_id = user.user_id
    	AND...
    You do not have permission to view the full content of this resource.

Recent Reviews

  1. Epi
    Epi
    5/5,
    A very useful query when you use borbole's query to move guests threads and post to a xenforo user since borbole's query won't update the thread counters.