Page 1 of 1

How many comments?

Posted: Tue Aug 14, 2007 5:34 pm
by Lothar
On my new blog (http://blog.telmarkt.de) a comment was added to category "CallCenter / Umfragen". I posted an answer to this comment. The entry is has now a comment count of 2. However, the statistics side bar knows only one comment. Are there different counters?

Re: How many comments?

Posted: Wed Aug 15, 2007 9:53 am
by garvinhicking
Hi!

Hm, that's strange. Could you check the Database table 'serendipity_comments' and see which columns are filled there?

The SQL query used by the statistics plugin is:

Code: Select all

SELECT count(id) FROM serendipity_comments WHERE type = 'NORMAL' AND status = 'approved'
So the only reason that the counts can differ would be that one of your 2 comments is either not the 'NORMAL' type (maybe a trackback?) or it is not approved?

Regards,
Garvin

Posted: Wed Aug 15, 2007 10:24 am
by Lothar
Garvin, the displayed counters are now the same. After some time - may be an hour - the display was correct.

I will watch the counters when new comments are added. And then I will query the database.

Posted: Wed Aug 15, 2007 10:32 am
by garvinhicking
Hi!

Ah, okay. The statistics sidebar plugin is cached! That's your problem. :)

You can change the caache timeout in the sidebar plugins config.

Regards,
Garvin