hello,

this means your server is located 5hours behind your location. in other words, your server's timestamp is 5hours behind of you. the stats record each entry based on the server's timestamp (of course!)

when you say "your joomla server time" is set to Detroit, you mean this is a joomla parameter? the timestamp used is always the server one, so... really the first thing I can say is: your server timestamp is not what your hosting company says it is.. is that possible?

by the way: the timestamp is actually recorded by the MySQL system (not PHP). with this I mean that maybe the PHP settings are set to central standard time, but it could be that the MySQL settings are setted differently (5hours behind). could you check this?

thanks!

Germi

If you host server provider allows you to set a personalized php.ini file, you have to set here the correct timezone managment (which is absentee at most of the mutual hosting providers using Plesk, CPanel...)

If you can't do that properly, the solution consists in adding at the end of

/includes/defines.php

and

/administrator/includes/defines.php

the following line :

date_default_timezone_set( 'Europe/Paris' ) ;

(that's for me, for you, set your own timezone, here is the official list

www.php.net/manual/fr/timezones.php )

Hope I understood correctly the subject and hope that can help ?!

that will NOT help because the issue here is the Timestamp of the MySQL server! NOT the PHP one!
PHP and MySQL are two separate things.

After an hour with a tech support person at my hosting company yesterday, he said that the php server and the mysql server were set to CST time and that he can't manually adjust them. He tried using the htaccess file as I had but it didn't work any better for him than it did me. He had no explanation for the 5 hour difference when there is only a 1 hour difference between EST and CST. He even checked my joomla settings and confirmed my setting were correct.

I guess I am stuck manually adjusting the time.

there is still another thing you can try:
open file /plugins/system/contentstats/contentstats.php and add this into line 411:

$fivehours = time() + (5 * 60 * 60);
$this->date_event = date('Y-m-d H:i:s', $fivehours) ;

Okay, I did that and it has gotten me to within an hour of my local time. It was 4:09 when I logged in and the timestamp said 17:09, so we are much closer.

well then just replace that "5" for a "6"!! like so:

$fivehours = time() + (6 * 60 * 60);

Perfect! Thank you very much for your help!

The modification in /plugins/system/contentstats/contentstats.php worded fine for me.

Thank