Resource icon

XF 1 Tip Rebuild user post counts (query)

Overview Discussion (0)
Compatible XF Versions
1.x
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. Log in or register now.
Author
ENXF NET
Views
519
Last update
Rating
0.00 star(s) 0 ratings
Join the discussion (0)

More resources from ENXF NET

Top