Had topics with no pagination for guest login. Sitemaps were not including these other pages.
Turns out the bug is due to a db call checking private=0 for topic posts and not counting those posts for items_count. The fix was to comment out the following section in class-posts.php
//else{
//If doesn't have "View Private Posts" access and not Owner, only return public posts
// $wheres[] = " " . $table_as_prefix . "`private` = 0";
//}
Hi @nando4,
This is not wpForo issue it comes from the MySQL version. Please see the description of the issue here: https://bugs.mysql.com/bug.php?id=81031
Here is the same issue:
https://wpforo.com/community/how-to-and-troubleshooting-2/topic-pages-disappeared/#post-25490
Spoke too soon. The problem persists and the only working workaround is to comment out the offending code in class-posts.php. More details at:
https://wpforo.com/community/how-to-and-troubleshooting-2/topic-pages-disappeared/#post-25853
Hi @nando4,
This is not wpForo issue it comes from the MySQL version. Please see the description of the issue here: https://bugs.mysql.com/bug.php?id=81031
I suggest you either update your MySQL version or try solution provided by antonM in this support topic: https://wpforo.com/community/how-to-and-troubleshooting-2/topic-pages-disappeared/#post-25496
