In support forum , Page navigation issue

[pranitdugad]

In support forums , when clicked on last page , for example ​https://wordpress.org/support/forum/multisite/page/700/ in this page, when clicked on page 764 or 763 or 762 there no content. so last page should end of listing content instead of showing empty pages with massage.

video: ​https://jmp.sh/pIplMAtz

[dd32]

This is caused by inefficiencies of bbPress at the scale of the WordPress forums.

https://meta.trac.wordpress.org/browser/sites/trunk/wordpress.org/public_html/wp-content/plugins/support-forums/inc/class-performance-optimizations.php?rev=13539&marks=288-293,369-393#L287

For example; For the OP, the number of topics is 22825 (761 pages), but according to the _bbp_topic_count meta_value it's 22942 (765 pages), and if I enable my moderation powers it's 22977 (766 pages).

If someone had a pending post in the forum they might have 1 or 2 more threads than someone else.

The only real way to calculate the correct number of pages for a given user is to query for all the matching threads, but that takes a SQL of several seconds, which isn't viable.

It does seem that _bbp_topic_count is probably incorrect for the forum, as it's close but not exactly the same as the other values.