Where a user's post goes into the Moderation queue for approval then when that post is approved the total board post count is not being incremented. This is, it would appear, to be because when the post is approved there are entries in the "post_delete_time" and the "post_delete_user" fields of the posts table.

I suspect the the problem is partly with the "set_post_visibility" function (phpbb\content_visibility.php - line 376) as that is where the "post_delete_time" is incorrectly being set but also it appears that at no point with post approval is the "add_post_to_statistic" function being called.

Resynchronising the statistics does in fact increment the total board count correctly