Re: [Slashcode-development] countComments problem

[shane <sh...@lo...>]

On Tuesday 07 October 2003 10:34, Christopher Winn wrote:
> Running Slash 2.2.5.
>
> So, I can't seem to display the number of comments within a story.
>
> I tried calling:
>
> my $commentcount = $slashdb->countComments($sid);
> print $commentcount;

I would do the following:

my $commentcount = $slashdb->countComments($sid);
use Data::Dumper;
print Dumper($commentcount);


That Data::Dumper is just one helluva useful perl module, imho.

> But that does nothing.
>
> slashd is running.. And I also can't seem to call it from within a
> template, as in:
>
> [% Slash.db.countComments(story.sid) %]

from your sql cli:

mysql> select sid,tid,commentcount from stories;

should look something like this: (garbled, if you're reading this from a 
non-fixed-size-font)

+------------------+-----+--------------+
| sid              | tid | commentcount |
+------------------+-----+--------------+
| 03/08/01/1127221 |   1 |            5 |

I think the commentcount is actually figured out, and *set* by the task 
daily_archive.pl. You'll want to check your slashd logs and make sure slashd 
is running, and daily_archive.pl is being run, and not erroring out.  You 
could, also, use runtask to run the daily_archive.pl by hand. But that's up 
to you. You should read the daily_archive code before doing so, atleast on a 
production system.

 Shane