Posted by: Sofy

Hi Wendell,

Posted by: Robert

@wendell,

1. Please deactivate wpForo (not uninstall), delete it, then search and install it again.
2. Then navigate to Dashboard > Forums > Dashboard admin page.
3. First click on [Update Forums Statistic], then [Update Topics Statistic] and finally the [Delete all caches].
4. After this, if you have a cache plugin, delete all caches of that plugin. Then do Ctrl+F5 on forum front and check it again.

Could you please swap the steps mentioning in the previous post:

First click on [Update Topics Statistic], then [Update Forums Statistic] and finally the [Delete all caches].

When I click Update Topics Statistic, it runs for a couple of minutes before getting a 502 error. I know that there is a warning on the wpForo Dashboard page saying that this could happen, but that the script is still running at the server. So I wait for a couple of hours before returning to the forum to check. As before, some of the forums are updated to show accurate post counts while others remain at zero.

Screenshot #1:
(shows that the Q&A forum was updated while others remain at 0)
https://cl.ly/2V1h3W3T2n13

Screenshot #2:
(shows that some forums were updated while others remain at 0, and one of them even shows -2!)
https://cl.ly/3e1P2h0m2Y0s

@wendell,

I think this is a database SQL performing cache issue. We'll investigate it further. At the moment guys from gVectors Team executed these four SQLs and all is correct now:

ALTER TABLE `wp_wpforo_posts` ADD KEY `forumid_status` (`forumid`,`status`);
ALTER TABLE `wp_wpforo_posts` ADD KEY `topicid_status` (`topicid`,`status`);
ALTER TABLE `wp_wpforo_topics` ADD KEY `topicid_status` (`forumid`,`status`);
UPDATE `wp_wpforo_forums` SET `wp_wpforo_forums`.`posts` = (SELECT COUNT(*) FROM `wp_wpforo_posts` WHERE `wp_wpforo_posts`.`status` = 0 AND `wp_wpforo_posts`.`forumid` = `wp_wpforo_forums`.`forumid`);

If anybody else whats to execute this SQL, please change the red marked wp_ table prefix with your database table prefix and click on [Delete all caches] button in Dashboard > Forums > Dashboard admin page after executing the SQL.

Thanks!

I'm sorry to carry on this thread, but some of them still show zero...

https://cl.ly/3o3s3i2u1b2S

https://cl.ly/1e0S1i022f1E

It's so random...

Hi @wendell,

We'll need admin accesses to find this issue.  Could you please send admin login details to support[at]gvectors.com email address  

Thanks @sofy. They already have it. 🙂