Time Zone Offset Problem

[bear1728]

hello, i installed the mod GOB Package Trackers from http://www.zen-cart.com/index.php?ma...oducts_id=1427, when i update the order status from admin, the time i set for my site is replaced by the server time for date added in status table.
i tried changing now() to date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR) in admin/orders.php and /admin/package_trackers.php, but it still doesn't work.
could you help ? thanks.

[gilby]

hello, i installed the mod GOB Package Trackers from http://www.zen-cart.com/index.php?ma...oducts_id=1427, when i update the order status from admin, the time i set for my site is replaced by the server time for date added in status table.
i tried changing now() to date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR) in admin/orders.php and /admin/package_trackers.php, but it still doesn't work.
could you help ? thanks.

That looks about right
Did you change it in all 4 places in that file?

[MartynG]

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

This simple mod works perfectly for me too

Many thanks Badger

[kcky]

thanks to newfu post. I finally get my zencart time zone correct.

[rlexyd]

Hope someone can help.

I'm based in Australia and have the Time Zone Mod installed on 1.3.9g.

My Server time is correct but my database is showing us time stamp?

How do I correct date/time for the database?

Regards,

[gilby]

Hope someone can help.

I'm based in Australia and have the Time Zone Mod installed on 1.3.9g.

My Server time is correct but my database is showing us time stamp?

How do I correct date/time for the database?

Regards,

The last working version is 139d
You would have to merge the mod yourself for it to work with 139g


I have not updated this mod as
I am working on a simpler replacement mod
So.... Watch this space

[rlexyd]

Thanks for that.

A quick question, which files need to be merged?

I tired winmerge but since I have made several other changes to certain files it is showing that the whole file needs merging and it's hard to see which timezone offset additions need to be merged in the 1.3.9f.

Regards,

[gilby]

Thanks for that.

A quick question, which files need to be merged?

I tired winmerge but since I have made several other changes to certain files it is showing that the whole file needs merging and it's hard to see which timezone offset additions need to be merged in the 1.3.9f.

Regards,

Assuming you are using the 139d mod version as a starting point
Download the full zen139d fileset
Use winmerge to see what the actual mods have been done to these files

Then merge these difference with the version you are using, 139f

btw Why not update to 139h first?

[dw08gm]

Happy New Year Gilby

I am in the midst of upgrading my store with mods Edit_Orders_3.03 and SuperOrders_3 (3.01?), wherein provision is made to create an audit trail of the date-time of any adjustments made to orders.

Due to the somewhat complex nature of these mods, I am wondering whether your new simplified version of TZO will remove the necessity of having to tinker further with these mods.

Thanks in advance.

[gilby]

Happy New Year Gilby

I am in the midst of upgrading my store with mods Edit_Orders_3.03 and SuperOrders_3 (3.01?), wherein provision is made to create an audit trail of the date-time of any adjustments made to orders.

Due to the somewhat complex nature of these mods, I am wondering whether your new simplified version of TZO will remove the necessity of having to tinker further with these mods.

Thanks in advance.

Yes it does.
No merging required of any other mods.
It fixes the problem at its source
Still testing to verify....