Time Zone Offset Problem

[newfu]

hi, thanks for the help previously.

so if i am from Singapore, what should i put ?

i tried to google but it always dun work.
Singapore, Singapore for GMT +8 ?

[newfu]

EDITED

http://sg.php.net/manual/en/timezones.php

i found it myself, for the benefit of others, it uses PHP date function, so yup,

[limelites]

This mod was working perfectly for me until an hour ago. I've not changed anything, but suddenly the following message has appeard in the header of my admin area:

Warning: putenv() [function.putenv]: Safe Mode warning: Cannot set environment variable 'TZ' - it's not in the allowed list in /home3/limelite/public_html/****ADMIN****/includes/extra_configures/time_offset.php on line 8
Warning TIME ZONE OFFSET ERROR! Time Zone Offset is set to +5 Hours. The difference between Server & Database time is -5 Hours.
Warning 2009-10-05 04:57:10: TZ Server Time
Warning 2009-10-05 09:57:10: Offset Database Server Time:

I remember I had similar messages at the install stage, but I added the optional files and edited the time_offset.php to this:

<?php 
//You can modify the TZ (Time Zone) by using one of the following offsets
//TZ=America/Los_Angeles
//TZ=America/Denver
//TZ=America/Chicago
//TZ=America/New_York

putenv ('TZ=Europe/London'); 
?>

Which did work, until now.

Anyone have any idea what's gone wrong?

I've tried changing the +5 in the admin My Store area to different cariables, +6 +4 etc., etc., but the same error every time.

Anyone?

[Defanci]

Hi,

I was having the same problem too

"Time Zone Offset is set to +13 Hours. The difference between Server & Database time is 2 Hours."

When I change the offset to +2 hours and the message swaps round:

"Time Zone Offset is set to +2 Hours. The difference between Server & Database time is 13 Hours."

Then I added the different together and changed it to +15, fixed the problem.

[gilby]

Hi,

I was having the same problem too

"Time Zone Offset is set to +13 Hours. The difference between Server & Database time is 2 Hours."

When I change the offset to +2 hours and the message swaps round:

"Time Zone Offset is set to +2 Hours. The difference between Server & Database time is 13 Hours."

Then I added the different together and changed it to +15, fixed the problem.

Its a bit cryptic...
When its set to +13 hours. It telling you that it is NOW +2 hours out

So...... Try +15 hours (+13 +2)

[totalsam]

Hey,

So how would you integrate this with ZC. I know the Time Zone Offset mod used MySQL functions to change the date, but there is apparently a better way to do it with php now pho has improved. Anyone got any ideas how to do this?

[gilby]

Hey,

So how would you integrate this with ZC. I know the Time Zone Offset mod used MySQL functions to change the date, but there is apparently a better way to do it with php now pho has improved. Anyone got any ideas how to do this?

There is 2 parts
Setting the php time
and fixing the mysql time

This mod is designed to adjust the mysql database time

The php time can be set with the set TZ=(your country/city)

[badger64]

Hi all

I know this thread is abit old but my host is based in the states and I'm in the uk.

Put this code in the .htaccess in the root of your site.

SetEnv TZ Europe/London

Works for me. Hope it helps.

Rgds
Badger

[bear1728]

this mod is so useful, i wonder if i could also set the time of reviews to my local time just as what it does to create_account and customer_order ?

[bear1728]

i use zencart 1.38a, do i need to update time zone offset mod to the newest version published on may 2nd 2010 ?