Post count bug?

[Alex]

I just realized that KingPhilip has over 8,000 posts. Last I noticed he had significantly less, somewhere around 2,000. If you view the list of his posts there's only 134 pages, at 15 per page that's about 2010.

 

Is this a bug with SMF, or was someone messing with the database, or what?

[trq]

It does seem excessive but, KingPhilip had been a mod (?), so allot of posts could be out of view or even just simple 'thread moved' posts. I haven't time atm or I'd run a query or two and take a look.

 

I know for a fact that something like 30% of my posts are those 'topic moved' things.

[Alex]

Well I'm pretty sure that he had around 2,000 posts sometime within the last week, and those topic moved posts do show on the "Your posts" page.

[Mchl]

There's (should be) a tool in administrator's panel to recalculate post counts (and other stats).

[trq]

Fixed.

[Daniel0]

I know for a fact that something like 30% of my posts are those 'topic moved' things.

 

Those don't count towards your total.

[Alex]

I know for a fact that something like 30% of my posts are those 'topic moved' things.

 

Those don't count towards your total.

Yes they do.

[Maq]

I know for a fact that something like 30% of my posts are those 'topic moved' things.

 

Those don't count towards your total.

 

Before they didn't but with the new version of SMF, they do.

[trq]

The totals are all a bit mixed when you look at the actual db.

 

mysql> select posts from smf_members where member_name = 'thorpe' limit 1;
+-------+
| posts |
+-------+
| 23201 | 
+-------+
1 row in set (0.00 sec)

mysql> select count(id_msg) from smf_messages where poster_name = 'thorpe' limit 1;
+---------------+
| count(id_msg) |
+---------------+
|         22931 | 
+---------------+
1 row in set (0.01 sec)

mysql> select count(id_msg) from smf_messages where poster_name = 'thorpe' AND subject LIKE '%MOVED%' limit 1;
+---------------+
| count(id_msg) |
+---------------+
|          1515 | 
+---------------+
1 row in set (2.28 sec)

 

 

[Philip]

Bastards!

[Cory94bailly]

There's (should be) a tool in administrator's panel to recalculate post counts (and other stats).

http://custom.simplemachines.org/mods/index.php?mod=2324

 

That's the one I'm using on my site, it works perfectly.