Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Posts
    39
    Plugin Contributions
    0

    Default Time Zone Offset Error

    Hello, I'm hoping someone may be able to help me.

    I'm running v1.3.8 with the latest patches and also the mod that allows me to use Australian time and not US time. I've setup the mod so that my time is pretty close, but I get the following in yellow up the top of the Admin screen...

    Warning TIME ZONE OFFSET ERROR!
    Time Zone Offset is set to +10 Hours.
    The difference between Server & Database time is 0.00666666666667 Hours.
    Warning 2009-08-28 17:47:31: TZ Server Time
    Warning 2009-08-28 17:47:07: Offset Database Server Time:

    I'm not exactly sure what it all means. All help greatly appreciated.

  2. #2
    Join Date
    Dec 2008
    Posts
    39
    Plugin Contributions
    0

    Default Re: Time Zone Offset Error

    Bump - Anyone have any ideas? I'm at a loss with this one.

  3. #3
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,021
    Plugin Contributions
    3

    Default Re: Time Zone Offset Error

    THere's a support thread here:

    http://www.zen-cart.com/forum/showthread.php?t=37565

    I haven't used this mod, but it sounds like it may be a sql problem.

  4. #4
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: Time Zone Offset Error

    Quote Originally Posted by 10gallons View Post
    Hello, I'm hoping someone may be able to help me.

    I'm running v1.3.8 with the latest patches and also the mod that allows me to use Australian time and not US time. I've setup the mod so that my time is pretty close, but I get the following in yellow up the top of the Admin screen...

    Warning TIME ZONE OFFSET ERROR!
    Time Zone Offset is set to +10 Hours.
    The difference between Server & Database time is 0.00666666666667 Hours.
    Warning 2009-08-28 17:47:31: TZ Server Time
    Warning 2009-08-28 17:47:07: Offset Database Server Time:

    I'm not exactly sure what it all means. All help greatly appreciated.
    It shows that there is 24 seconds difference between your adjusted mysql server time and your php time.
    Possibly because they are on different servers.

    The mod appears to be working fine for what you want.

    Either ignore this annoying message
    or... remove the "optional" file that checks this and replace the original
    \admin\includes\header.php
    or... rework the logic of this file so that it ignores differences of a minute or so instead of checking down to the second.

  5. #5
    Join Date
    Dec 2008
    Posts
    39
    Plugin Contributions
    0

    Default Re: Time Zone Offset Error

    Quote Originally Posted by gilby View Post
    It shows that there is 24 seconds difference between your adjusted mysql server time and your php time.
    Possibly because they are on different servers.
    I did get my site moved from one server to another, so that may explain that. Is that a problem?Am in at risk of running into any problems because of that?

    Thanks.

  6. #6
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: Time Zone Offset Error

    Quote Originally Posted by 10gallons View Post
    I did get my site moved from one server to another, so that may explain that. Is that a problem?Am in at risk of running into any problems because of that?

    Thanks.
    Did they move the mysql database as well to your new server or are you still accessing the old database on the previous server?
    If so you will be in trouble when they delete your account on the old server.

    If thats not the issue then a few seconds difference should not make any difference

 

 

Similar Threads

  1. 1064 You have an error in your SQL syntax - Time Zone Offset
    By clipegg in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 28 Oct 2010, 04:37 AM
  2. Time Zone Offset -- Fixing a SQL syntax error?
    By xman888 in forum All Other Contributions/Addons
    Replies: 14
    Last Post: 16 Apr 2010, 03:38 PM
  3. Time Zone Offset
    By harry2cool in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 26 Jul 2006, 09:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg