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.