Time Offset by 6 hours?

[Arie]

OK, I think I can solve most problems, but this one has be baffled :erm:

All was working fine. I *did* restart MySQL last night, after tweaking 1(!) setting:

I increased sort_buffer_size=512KB to sort_buffer_size=1M

This morning I noticed that these times are off by 6 hours:

You last visited xxx
Post time (shown on new posts & replies)

The forum time shown at the bottom are correct (in my case All times are GMT +1. The time now is xxx).

Checked server time

date
Sat Mar 10 07:54:42 CST 2012

That's correct.

Check MySQL time

mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2012-03-10 07:55:31 |
+---------------------+
1 row in set (0.00 sec)

Both Apache & php.ini are set to the correct time zone

php.ini

date.timezone = 'America/Chicago'

httpd.conf
SetEnv TZ US/Central

What am I missing? I've been running my forum for about 2 weeks on this new server (and years on the old one). I had been tweaking MySQL for the last while and restarted previously, no problems until this morning...

[kh99]

Did you check your own timezone setting in your profile?

[Arie]

Yea, sorry, forgot to say, all users are seeing the same. I'm thinking it is a cookie problem, but no idea where that came from...

[Max Taxable]

The default time setting.

[Arie]

The default time setting.

?

You mean Default Time Zone Offset?

Has no influence. Like I said, the time shown at the bottom of the forum is correct.

--------------- Added 1331409770 at 1331409770 ---------------

OK... I disabled all plugins on my test forum (by un-commenting define('DISABLE_HOOKS', true); ) that solved the problem.

Which still begs the question where the problem lies and what made it surface, so now I'll have to start checking the individual plugins.

Only thing I did in the last few days was adding plugin code to allow for 'local' invocation of my ad server, so I'll check if that's somehow messing with the cookie...

--------------- Added 1331413208 at 1331413208 ---------------

OK, it is the local invocation code that's messing up things... now I got to find out how to get it fixed, preferably without returning to the Javascript tags...

--------------- Added 1331430340 at 1331430340 ---------------

I wish there was a better option for ad serving then OpenX. What a bunch of incompetent XXXXX Seems I run into a bug that's been reported to them way back in 2009 & never fixed. Found my solution here: http://forum.openx.org/index.php?showtopic=503421161&view=findpost&p=71370

Thanks OpenX, for wasting a day of my time!