SEO-Board: Free, Fast and Search Engine Optimization Friendly Forum Script
»User: »Password:   Remember Me? 
Posted:  30 Mar 2005 23:36
Hello,

could it be there is a little problem with recounting stats? I just did it and it now shows

Forum has 62 topics and 11 replies for a total of 73 posts.

However there are around 200 or more

Any idea what's causing this?
Posted:  30 Mar 2005 23:55
Have you made changes to the forums data table (inserted additional fields)?
Posted:  30 Mar 2005 23:59
Actually, there is a problem. I am working on fixing it.
Posted:  31 Mar 2005 00:09
Nope no changes at all But I guess (following your reply) that you just tested it yourself
Posted:  31 Mar 2005 00:12
Hmmm I wonder: Why not just count the post rows? Generally you don't need to do the big math (topics + replies) - you could just count the post rows as topic details are in there anyway - or not?
Posted:  31 Mar 2005 00:13
To fix the bug:
1 - open /code/functions.php
2 - in function fix_forum_stats() remove the "GROUP BY topic_id" at the end of the 2nd query
3 - rerun "recount forum stats"

Sorry. Dumb bug. I'll update the seo-board .zip file.
Posted:  31 Mar 2005 00:17
Finally I found a real bug and not an own mistake like the report I did before
Posted:  31 Mar 2005 00:20
Let me know if it works now.
Posted:  31 Mar 2005 00:22
Yep your solution fixed it.