Time Zone Offset Problem

hello, i installed the mod GOB Package Trackers from http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_51&products_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.

bear1728:

hello, i installed the mod GOB Package Trackers from http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_51&products_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?

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

This simple mod works perfectly for me too :smile:

Many thanks Badger

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

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,

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,

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

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,

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,

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?

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.

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.

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

New user -- just finished installing and configuring 139h.

Noted the time zone error during testing and found this thread.

Should I wait before applying the TZ add-on because you (Gilby) are about to provide an update yourself?

Our store does not go live for another two weeks so I would rather apply this fix once if you know it will be available.

Thanks

Colfax:

New user -- just finished installing and configuring 139h.

Noted the time zone error during testing and found this thread.

Should I wait before applying the TZ add-on because you (Gilby) are about to provide an update yourself?

Our store does not go live for another two weeks so I would rather apply this fix once if you know it will be available.

Thanks

Hopefully, it should be available next week

Hi,

Great mod, all worked fine for the UK, install and time update seemed to easy to do :clap:

One question, will the time update itself when our clocks go to BST?

Best Regards,

Dave

inthecup:

Hi,

Great mod, all worked fine for the UK, install and time update seemed to easy to do :clap:

One question, will the time update itself when our clocks go to BST?

Best Regards,

Dave

Yes it should.
I assume you are using a version of zen up to 1.3.9d
This mod is not supported after this version

Please use the new replacement mod instead Time Zone Fix.

The new mod is:
Much simpler and overwrites only 1 core file.
When working it fixes all known Time Zone problems

There is a new Support Thread for this new mod.

There is no need to update an existing Time Zone Offset mod if it is working fine for you.

You should use the new Time Zone Fix mod.
If updating to a new version of Zen-Cart.
And for all new Zen-Cart installs.

Hi,

I used the new version of the fix for version 1.3.9h, I have now noticed that even though my admin time is correct the time on the updates for orders is wrong by about -6 hours,

Any thoughts ???

Dave

inthecup:

Hi,

I used the new version of the fix for version 1.3.9h, I have now noticed that even though my admin time is correct the time on the updates for orders is wrong by about -6 hours,

Any thoughts ???

Dave

:clap:Panic over, I did not complete stage 3 of the fix.....I have now and all works fine in v1.3.9h

Great fix :yes: