vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Time Offset by 6 hours? (https://vborg.vbsupport.ru/showthread.php?t=279862)

Arie 03-10-2012 12:56 PM

Time Offset by 6 hours?
 
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

Quote:

date
Sat Mar 10 07:54:42 CST 2012
That's correct.

Check MySQL time

Quote:

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

Quote:

date.timezone = 'America/Chicago'
httpd.conf
Quote:

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 03-10-2012 03:50 PM

Did you check your own timezone setting in your profile?

Arie 03-10-2012 04:03 PM

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 03-10-2012 04:05 PM

The default time setting.

Arie 03-10-2012 04:22 PM

Quote:

Originally Posted by Max Taxable (Post 2308307)
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 [DATE]1331409770[/DATE] at [TIME]1331409770[/TIME] ---------------

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 [DATE]1331413208[/DATE] at [TIME]1331413208[/TIME] ---------------

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 [DATE]1331430340[/DATE] at [TIME]1331430340[/TIME] ---------------

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?sho...ndpost&p=71370

Thanks OpenX, for wasting a day of my time!


All times are GMT. The time now is 06:49 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01131 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete