Forums

Two Bugs - Time incorrect and Showing 0 comments with myBlog

higgalls 19 Mar, 2009
Hey,

I just installed Chrono Comments today, and I am impressed with it. However, I have 2 problems with it.

1) I am using it on myBlog, and it works except when a comment is added, it still says "Read 0 Comments...". If you click on it, the comment is definately there. Any ideas?

2) The time in the front-end for the submission of the comments is incorrect. It is out about 10 hours or so. The time in the back-end is correct. I have the timezone in the admin of Joomla set as GMT + 10 (I am in Sydney).

I have searched your forums and haven't found any solutions to these problems.

Any help is greatly appreciated.

Cheers,
Chris🙂
Max_admin 25 Mar, 2009
Hi Chris,

#1- I don't think this version of ChronoComments supports myblog
#2- this has been posted here before with the fix! and will be fixed in the next release!

Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
higgalls 25 Mar, 2009
Hi,

I have fixed the time problem.

Will myBlog be supported in the next version?
Max_admin 25 Mar, 2009
I will try to test using it!

Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
higgalls 25 Mar, 2009
Thanks.

If you can let me know how you go with it then it would be great, as I am trying to determine whether to switch commenting systems to one that works with myBlog or not, as I really need this part of it working.

Thanks.
Max_admin 26 Mar, 2009
Hi, well, I didn't start updating ChronoComments yet but it will get a big update once I'm free from the new Chronoforms release!

Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
higgalls 26 Mar, 2009
Ok, I have just figured out what the problem is, but don't know how to fully resolve it.

Basically, in the database table chrono_comments, if I change the component field to com_myblog (instead of com_content) for the comments, it will now display the correct comment count.

HOWEVER, when you click on "Read 1 Comments", it ends up going to the page and there are no comments listed.

The reason this happens is that in the blog listing, where it says "Read 1 comments", it is a com_myblog page, however, when you click on the "Read 1 comments" link, it is not using myblog, but instead is using com_content.

Can you think of any quick resolution for this?
higgalls 27 Mar, 2009
Quick question:

If I wanted to change the code that does the count of comments and matches it with the component=com_content (for example), which file would I edit, and where abouts is it?

I know what the problem is, and I have tried to look into where the component field is being brought from the database, but I just can't seem to fine the right SELECT statement.

Basically, I want to try removing the big which says where component=com_content (or com_myblog depending on the page I am at) to see what that will do, and then see if I can make a quick hack to make it fully working for myBlog.

Any ideas? File and line of code would be awesome🙂
higgalls 28 Mar, 2009
Ok, it seems like a lot of fiddling around, I have finally got it all WORKING. HOORAY.

Go into plugins/chronocomments.php, and do a search for the following string:
component = '".JRequest::getVar('option')."' AND

Go to the SECOND instance of that search (not the first), and delete that code so that the whole query reads:
$query = "SELECT * FROM #__chrono_comments WHERE pageid= '".$pageid."' AND published='1' AND verify='1' ORDER BY datetime ASC";

Save, and then it should now work with myBlog.

Now, there is only 1 consequence I can see that will come from this. I shouldn't have this problem, since the only things I am using comments on (at this stage) is with items stored in the jos_content table in the database (myBlog saves the blogs in the same database table along with normal articles), but if you have ChronoComments working with other systems that uses a separate table to store its content, then if you have duplicate id's it might show up both lots of comments for each article.

For example, if you have an article named "Facebook" as a normal article in Joomla, which has an id of 36, and then you have another component with an item called "BBQs" in a table just for that component, which also has an id of 36, if ChronoComment works for both the Joomla articles and the component, then when you go to the Facebook page, it will list all comments for the Facebook page but also the BBQs page, and vice-versa.

Anyway, hopefully there will be a proper fix for this soon, but this is a good system at the moment for me.

Hope this all makes sense (and sorry I didn't provide a line number for the code... I don't have any editing software installed that shows line numbers).

Cheers,
Chris🙂
Max_admin 28 Mar, 2009
Hi Chris,

Thanks for sharing the fix and this will be added in the next version so it can work with any extension!😉 sorry for not responding earlier but I'm having a very busy time with Chronoforms!

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.