From: shane <sh...@lo...> - 2003-10-08 09:41:49
|
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 |