News comments don't work

I am getting the same with mine as well, whether trying to add comment to news as either admin or member

URL to your eFiction: http://www.pretendercentre/missingtest/index.php
Your version of eFiction: 3.2
Latest Patche(s): Yes (also the latest 3.2 fix)
Any mods installed?: no
Have you modified your eFiction?: No.
Version of PHP: 4.4.3
Version of MySQL: 5.0.27
Have you searched for your problem: Yes
Other Notes: in 3.1.1 everything worked perfectly.

also suffering from this problem.

Just want to add - Thanbks to Tammy for all the hard work she does on this script.

It's a bug.  On line 43 of news.php add a ! in front of $cid.

if(!$cid) {

thanks tammy, that will let you post a comment now but on the index page, the count comments is still zero, although the comment is there

http://www.pretendercentre.com/missingtest/index.php  count = 0

http://www.pretendercentre.com/missingtest/news.php?action=newsstory&nid=1  count = 2

Yeah.  I'll have that fixed soon.

Have the same problem of the count comments 0, even if there is a comment there. °° Upgraded today to 3.2

Oh, eep, I reported something similar on Tammy's site... I thought it was an issue with the recs module, but it might be this.

Sorry to be a bother, Tammy- just wondering how the fix is going? Thanks in advance!

Here's what I'm using on my archive to fix this problem. This can be a temporary fix in case Tammy has something else in mind with the code.

Edit your blocks/news/news.php file

Find:

$newsquery = dbquery("SELECT nid, author, title, story, UNIX_TIMESTAMP(time) as date, comments FROM ".$tableprefix."fanfiction_news ORDER BY time DESC LIMIT $numupdated");

Replace with:

$newsquery = dbquery("SELECT n.*, UNIX_TIMESTAMP(n.time) as date, count(c.cid) as comments FROM ".$tableprefix."fanfiction_news as n LEFT JOIN ".$tableprefix."fanfiction_comments as c ON  n.nid = c.nid GROUP BY n.nid ORDER BY n.time DESC LIMIT $numupdated");

3.2.1 taken care of the newscomments yay

thanks tammy

Where is 3.2.1?

Just go to the downloads section and download the zip it is called 3.2 sitll.
I just ran it and it fixed the news comments, havent had chance to investigate much else yet, but so far it is great!!!

Thanks, will give it a go 🙂