UBB.Developers Forums UBB.threads 7 Development How Do I? How to fix the post count following a prune?

UBB.threads™ 6.5.1b5

Have just pruned the forums and was wondering how to correct the post counts in the columns for the number of posts etc.

Thanks.

There's quite a few 'cleanups' posted here:

https://www.ubbdev.com/forum/showflat.php?Number=99219

Gotta be careful that you don't break your site tho

Run this one to see what forums have incorrect post counts:

SELECT Bo_Keyword, Bo_Total, COUNT(*) AS ActualPosts FROM w3t_Boards
JOIN w3t_Posts ON B_Board = Bo_Keyword GROUP BY Bo_Keyword HAVING
Bo_Total != ActualPosts


Then run this one to fix'em:


UPDATE w3t_Boards
SET Bo_Total = '1737'
WHERE Bo_Keyword = 'UBB2'

(changing the '1737' and 'UBB2' to the info you have

thankyou, I spent an hour looking for the individual pieces