TOPIC: time is not correct

joomla has correct time but not joomla comments

for example i posted a comment and it says
2009-06-28 08:35:22
when it should be 19:35
in posting its just what u want to be first date or year or time but i cannot find anything to change hour

alpha3 has this problem. I can send you beta1 - this problem is repaired there.

Hi, I have a smimilar problem but it's not related to posting a new comment but to editing an old one. Not sure why, but when my moderator edit a comment the time then show a higher values... + 2hrs. When someone post a new comment the time is correct until someone edit the text.

Please advise. I could live with that, but I am also using your module which shows posts sorted by time and when we edit a comment than this edited comment is in the first place.

edit: I am using the latest beta version. Upgraded just today. I also checked on my mysql and the date there is correct but not on the front page.

In the Joomla global configuration, make sure the Locale Settings is the same as the Moderators's individual timezone - check that in User Management. I have both mine set to GMT +10:00 which is my timezone.

Also make sure you're using JoomlaComment 4.0 Beta1 as it fixes timezone bugs.

Both moderator and local time is set to same value. The problem still remains... when you post a comment - time is correct, when you edit a comment time goes ahead.

I will check that. I suppose it is a bug.

Could it be because the original comment writer has a different timezone to the moderator who edits the comment?

If that's the case, I think that's by design. The moderator edited the post, so the date changes to reflect that edit. Am I wrong?

Anywho, I think the solution is to provide an option (or hardcode it, not sure) to make the Editing of a comment not update the time and date.

If i'm wrong, then I guess it is some kind of bug

As I mentioned several times the database design of joomlacomment is a little bit bad. There is no field for storing the edited date, there is no field to store who edited the comment and so on. We should address those problems with 4.1.

So shall I wait for version 4.1 or is there something that can be done now to fix it?

Thank you for your help.

Say you edit post at 13:00, once published, the time goes ahead from your current time so in this case it would show 15:00. So your "last comment" modul will show them in the first place eventhough the time did not happen yet and will overwrite all regular posts.

Would it be possible to provide me with a link or send me the previous alpha version via email? My site can't live with the time issue as it confuses the latest comment module. I got 1000+ visitors daily and with this funcionality the are not able to stay on top of new comments.

I would rather wait for a fix and in the mean time use the previous version.

Please advise.

Sorry for the delay!
here is what you have to do to make it work with beta1
open components/com_comment/joscomment/comment.class.php

find the function editPost() at around line 1098:

find this linesand change it to:
This should work!

Super! It works! Thank you so much for your effort.

You are welcome
A nice review here would be great!
extensions.joomla.org/extensions/contact...omments/4389/details

Sure !

What does that code do Daniel? Is that basically a way for people/administrators to edit a comment, and the date/time doesnt change (staying on the original)?

If so, we could add an option in the backend to toggle between this behaviour

No, that is just the edit function. I have forgotten to update the way we store the time.
We will need a new database field modified - to stare the date when a moderator edited a comment.

Wow i'm completely lost. OK so that code just fixes the time error from when a comment is edited, and still updates the "Comment Date" with the date it was edited....?

exactly

OK! Is there any reason we can't commit this to the beta 2 trunk?