By n00bster on Tuesday, 08 April 2014
Posted in General Issues
Replies 9
Likes 0
Views 1.2K
Votes 0
when my users made a comment on a reply and they reload the site, the time of the comment is set back for one hour.
more infos in the video. i do not know where and why this happens. please take a look.
http://www.screencast.com/t/ZCHMHBT5MFU
Hello n00bster,

Sorry for late reply to this,
Is it possible provide us with your Joomla backend and FTP access so we can help you check on this? Please advise.
·
Tuesday, 08 April 2014 10:25
·
0 Likes
·
0 Votes
·
0 Comments
·
login details added
·
Tuesday, 08 April 2014 15:02
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello n00bster,

Sorry for late reply to this,
May i ask do you have do any customization on Easydiscuss?
If no, can i have a permission to help you re-upload/install the Easydiscuss from your backend extension manager? Please advise.
·
Wednesday, 09 April 2014 00:25
·
0 Likes
·
0 Votes
·
0 Comments
·
it is my dev site, no problem you can reinstall ED when you need
·
Wednesday, 09 April 2014 01:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello n00bster,

Sorry for late reply to this,
I have tried re-install the Easydiscuss component in your site, it seems like doesn't help much here.
May i know how you set the timezone from your SQL and the server timezone from your site? Please advise.
·
Wednesday, 09 April 2014 12:57
·
0 Likes
·
0 Votes
·
0 Comments
·
my joomla site/server timezone is set to "vienna". the sql timezone is set to "system".
·
Wednesday, 09 April 2014 14:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello n00bster,

I'm really sorry delayed of this reply,
After i debugging in your site, I'm noticed that :
Example I comment that duration time is 5am.

SELECT DATEDIFF('. $db->Quote( $date->toMySQL( true ) ) . ', // I'm not sure that what reason this can't return to offset, then this one is showing 5am (this should be 7am)
DATE_ADD(a.`created`, INTERVAL '.$offset.' HOUR ) // created date ->5am + offset 2hour = 7am


Replace with,

$query = 'SELECT DATEDIFF(now(), DATE_ADD(a.`created`, INTERVAL '.$offset.' HOUR ) ) as `noofdays`, '
. ' DATEDIFF(now(), DATE_ADD(a.`created`, INTERVAL '.$offset.' HOUR ) ) as `daydiff`, '
. ' TIMEDIFF(now(), DATE_ADD(a.`created`, INTERVAL '.$offset.' HOUR ) ) as `timediff`, '
. ' a.* ';
$query .= ' FROM `#__discuss_comments` AS a';

JoomlaFolder\components\com_easydiscuss\models\posts.php

Above code should be fix in your current issues, because only your site having this issues, so you have to backup this file before you update to lastest version of Easydiscuss in the future. Hope this help.
·
Thursday, 10 April 2014 15:04
·
0 Likes
·
0 Votes
·
0 Comments
·
hi, i have checked your new ED version 3.2.9422. it looks like that you have implemented your hack above, nice one
but after i have updated my test site the comment time is showing again a delay from one hour. no matter what timezone i use in the joomla config (UTC or Vienna). the wired one is when i write a new discussion the time is right, only the comment time is going wrong.
·
Friday, 11 April 2014 15:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello n00bster,

You have to replace again the hack what i provided for you at above. Because we are not sure that was only happening in your site.
·
Friday, 11 April 2014 15:29
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post