The number of topics and posts did not get updated on the main page.

I checked the database, I found that NumTopics and NumPosts did not get updated in table yaf_forum????

Then I found that the store procedure yaf_forum_updatestats. I do not think it counts the number correctly??

I think there should be more condition in WHERE clause which is y.IsDeleted = 'False'.