wpForo 1.x.x [Solved] Forum and topic statistic issue, zero posts
- Please deactivate wpForo (not uninstall), delete it, then search and install it again.
- Then navigate to Dashboard > Forums > Dashboard admin page.
- First click on [Update Forums Statistic], then [Update Topics Statistic] and finally the [Delete all caches].
- 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.
(shows that the Q&A forum was updated while others remain at 0)
(shows that some forums were updated while others remain at 0, and one of them even shows -2!)
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.
I'm sorry to carry on this thread, but some of them still show zero...
It's so random...
We'll need admin accesses to find this issue. Could you please send admin login details to support[at]gvectors.com email address