YAFLogo

tecman
  • tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
8 years ago
We are using the release version 2.2.3. The number of posts is not changed for every user. Has this bug been fixed in the latest release of YAF?
Sponsor
logan
  • logan
  • 100% (Exalted)
  • YAF Leader
tecman
  • tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
8 years ago
I checked the settings of every forum. Strange, but one of them had this "no count" option set. I do not remember that I ever touched it...

Now the problem is how to set the post count for every user to the proper value - some posts were not counted while this "no count" option was in effect. Is there a way to rebuild the user data that contain post count?

tecman
  • tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
8 years ago
Bump #1. Can we rebuild or update the user data table to set the post count to proper values? I think it could be a SQL script or something similar we can execute. It would be nice to have such a function integrated into the Admin panel.
logan
  • logan
  • 100% (Exalted)
  • YAF Leader
8 years ago
Found this.

http://yetanotherforum.net/forum/posts/m64946-Importing---Pasting-Messages-to-migrate-to-YAF#post64946 

update yaf_user

set numposts =

(select count(userid) from yaf_message

where yaf_user.userid = yaf_message.userid)

Under Hostsettings Tab / Database tab / Run SQL Query

Copy and Paste above into query area and click run query


test
tecman
  • tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
8 years ago
This helped to solve the problem completely!!

Thank you.