Time Zone Offset Error

[10gallons]

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.

[10gallons]

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

[stevesh]

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.

[gilby]

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.

[10gallons]

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.

[gilby]

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