topic Re: Christmas Photo Competition in Community Site Feedback

Forum Stats look wrong in some cases

Tue, 08 Jan 2008 08:50:50 GMT

Incidentally, I've seen a couple of incorrect ones, but the post counts look right based on previous post counts don't they?
Split from the Christmas Photo Competition thread.

Re: Christmas Photo Competition

jelv — Tue, 08 Jan 2008 09:09:08 GMT

Quote from: James_H
Which parts are wrong?

The bit that says you've jumped above me in the league table!

Re: Christmas Photo Competition

Tue, 08 Jan 2008 09:14:55 GMT

Have you seen that the person who is 9th in the 'Topic Starters' table only has 1 post, even though they have started 194 topics......

Re: Christmas Photo Competition

jelv — Tue, 08 Jan 2008 09:38:12 GMT

I hadn't - but rjbashford being in 7th when he has made no posts at all is a bit clever!

Re: Christmas Photo Competition

Tue, 08 Jan 2008 09:39:39 GMT

Don't mention it to Colin, in case he disassociates my old posts again.

Re: Christmas Photo Competition

Colin — Tue, 08 Jan 2008 10:15:22 GMT

Feel free to tell me... I'd rather know and be able to fix it than not know.

Re: Christmas Photo Competition

Tue, 08 Jan 2008 10:24:54 GMT

I presume you've seen the ones we mentioned in #62 and #63 now.
I've not spotted anything else, but those do stand out a lot more than they would if say Peter V had the wrong number of topic starts attributed to him.

Re: Forum Stats look wrong in some cases

James — Tue, 08 Jan 2008 10:28:27 GMT

Yeah, my post count is about 5000 posts short aswell.

Re: Forum Stats look wrong in some cases

Colin — Tue, 08 Jan 2008 10:31:30 GMT

James, your post count is fine.
In relation to this, I know why and have got the fix awaiting SQL review.

Re: Forum Stats look wrong in some cases

Tue, 08 Jan 2008 10:32:05 GMT

Not so fast soldier!
I think your maths is letting you down James, your post count looks to have been inflated by a factor of ten somehow.
Perhaps Colin can reduce it to 770 or so for you.

Re: Forum Stats look wrong in some cases

Colin — Tue, 08 Jan 2008 10:54:52 GMT

Looks about right to me... from querying a copy of the PHPBB database:

+------------+------------+
| username   | user_posts |
+------------+------------+
| lestones   |        612 |
| peterstone |        270 |
+------------+------------+

Re: Forum Stats look wrong in some cases

Colin — Tue, 29 Jan 2008 18:58:49 GMT

This appears to be fixed.

Re: Forum Stats look wrong in some cases

Colin — Wed, 06 Feb 2008 17:49:54 GMT

If this is fixed, can it be moved to Resolved Bugs?

Re: Forum Stats look wrong in some cases

Wed, 06 Feb 2008 18:02:23 GMT

Yup - moving it now.