| Posted: 30 Mar 2005 23:36 |
|
|
|
Registered User Currently Offline
|
Posts: 12
Join Date: Mar 2005
|
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 |
|
|
|
Administrator
|
Posts: 1223
Join Date: Mar 2005
|
|
Have you made changes to the forums data table (inserted additional fields)?
|
| Posted: 30 Mar 2005 23:59 |
|
|
|
Administrator
|
Posts: 1223
Join Date: Mar 2005
|
|
Actually, there is a problem. I am working on fixing it.
|
| Posted: 31 Mar 2005 00:09 |
|
|
|
Registered User Currently Offline
|
Posts: 12
Join Date: Mar 2005
|
Nope no changes at all But I guess (following your reply) that you just tested it yourself
|
| Posted: 31 Mar 2005 00:12 |
|
|
|
Registered User Currently Offline
|
Posts: 12
Join Date: Mar 2005
|
|
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 |
|
|
|
Administrator
|
Posts: 1223
Join Date: Mar 2005
|
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 |
|
|
|
Registered User Currently Offline
|
Posts: 12
Join Date: Mar 2005
|
Finally I found a real bug and not an own mistake like the report I did before
|
| Posted: 31 Mar 2005 00:20 |
|
|
|
Administrator
|
Posts: 1223
Join Date: Mar 2005
|
|
Let me know if it works now.
|
| Posted: 31 Mar 2005 00:22 |
|
|
|
Registered User Currently Offline
|
Posts: 12
Join Date: Mar 2005
|
|
Yep your solution fixed it.
|