tecman
  •  tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
2017-02-03T15:07:39Z
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
2017-02-07T16:00:10Z
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
2017-02-10T09:43:09Z
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
2017-02-11T14:37:08Z
Found this.

http://yetanotherforum.n...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
2017-02-14T15:45:57Z
This helped to solve the problem completely!!

Thank you.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved