Thread count is wrong

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
1/11/2014 8:54:53 AM
blaataap
Gravatar
Total Posts 23
View Posts

Thread count is wrong

Hi Joe,

It seems that somehow the calculation of thread counts went wrong over the past time and now the thread count in "select threadcount from mp_forums" is all wrong. For example I have one forum that is at "-21" so the DecrementThreadCount is probably fired to many times or something.

Im not sure if it works correctly now but is there a way to reset the counter? If there is none on hand would it be a good idea to do a mssql update on Forums to reset the ThreadCount field with a count()?

 

1/22/2014 9:44:08 AM
blaataap
Gravatar
Total Posts 23
View Posts

Re: Thread count is wrong

Hi Joe,

Is any1 able to answer my question? I might have put this in the wrong forums but if someone needs more information or if i can do anything pelase let me know..

Thanks!

 

1/22/2014 10:00:27 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Thread count is wrong

Hi,

There is a new release of mojoPortal coming very soon which includes changes to the forum thread count logic that should fix the problem. We got rid of the decrement and increment logic and made it use the sql count function whenever it updates the thread count. So after upgrading to the new version it will correct itself when a new thread or post is made.

In the meantime you could correct it by running a sql query to get the actual count.

Hope that helps,

Joe

1/22/2014 4:00:35 PM
blaataap
Gravatar
Total Posts 23
View Posts

Re: Thread count is wrong

I updated to recent version 2 weeks ago and indeed the thread counts are good now. It just needed a new thread, awesome thanks!

You must sign in to post in the forums. This thread is closed to new posts.