FIX FOR "View/Add Comments (0)" When there are actually comments on a mablog entry

NOTE THIS IS A MAMBLOG BUG NOT AN MXCOMMENT BUG, BUT RELATED TO MXCOMMENT INTEGRATION. I HAVE TESTED THIS IS MAMBO ONLY NOT JOOMLA

Switching on debug mode in mambo global configuration highlighted the error

You need to edit ../components/com_mamblog/showblogs.php

Search for function showCommentLink( $id ) {

Look just below this for the lines...


and replace with





If you do not want "View/Add Comments (0)" to show at all he simplest hack is to comment all the lines between case "mxcomment": and the next line that starts with case by putting // characters at the front of each line. I am working on a change to mamblog that would let you switch this on and off in the admin back end.....

I had this issue in the past when I used MxComment on a community site I developed and had to hack the Mamblog component to get it to work right. If I can remember what the hack was (or if I have a backup of the site) I'll try to look it up and post it.

--edit--
Nevermind - didn't realize you had already posted a solution
--end edit--

We ended up going with MyBlog because I thought it was a better component (and still cheap for an enterprise solution). As a side note we are also using JomComment on that site as well. I love the AJAX posting and updates and wish MxComment had the AJAX features, but MxComment is a much more well-rounded component (read more, social bookmarking, rating, etc).

That being said, I still use MxComment on my own personal site. <br /><br />Post edited by: joshua.lyon, at: 2008/01/15 20:35

Ohh, I know this post is old, but I'm adding my comment for anyone who is trying to fix this count feature. It works, but leave out the // that shows in front of the 'fixed' code.

Fixed code:

case &quot;mxcomment&quot;: $database-&gt;setQuery( &quot;SELECT count(*) FROM #__mxcomment WHERE component='com_mamblog' AND contentid='$id' AND published='1'&quot; ); $database-&gt;setQuery( &quot;SELECT count(*) FROM #__mxc_comments WHERE contentid='$id' AND published='1'&quot; );


Put this all on the same line (no breaks).

Can't tell you how happy I was that someone posted this fix. I don't know how to code, but I did recognize that the // wasn't supposed to be there (after trying for HOURS because I think that mamblog with mxcomment are awesome together!

Thanks:side:

of course my post above doesn't show correct spacing. Use the fixed code from the original post, but just leave out the // (and still keep the code all on one line, but with the tab spacing, etc.).

The link you provided goes nowhere. I am having the same issue as the above where on the article page the "View/Add Comments (0)" always displays (0) even though comments exist. I am running Mamblog 1.0 on Joomla 1.0.12 amd MaxComment 1.0.9. Thanks!