tecman
  • Posts: 176
  • Joined: 20/09/2013
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
  • Posts: 309
  • Joined: 15/03/2008
Did you check that the forums are not set to no count?

http://yetanotherforum.net/forum/posts/m59614--Solved--Post-Count-remains-0#post59614 
test
tecman
  • Posts: 176
  • Joined: 20/09/2013
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
  • Posts: 176
  • Joined: 20/09/2013
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
  • Posts: 309
  • Joined: 15/03/2008
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
  • Posts: 176
  • Joined: 20/09/2013
This helped to solve the problem completely!!

Thank you.
Users browsing this topic
    Forum Jump  
    • You cannot post new topics in this forum.
    • You cannot reply to topics in this forum.
    • You cannot delete your posts in this forum.
    • You cannot edit your posts in this forum.
    • You cannot create polls in this forum.
    • You cannot vote in polls in this forum.

    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