Page 8 of 9 FirstFirst ... 6789 LastLast
Results 71 to 80 of 83
  1. #71
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by Woodymon View Post
    Thanks, meant to put a ? mark at end of my last sentence. So in my admin orders page Paypal is showing the correct Pacific time in it's time stamps, but the Zen Cart comment entries shows two hours ahead (Central time) for its time stamps. And so I uploaded the time-zone_fix.php in the two respective directories

    putenv ('TZ=America/Los_Angeles');

    but still see the timestamps in admin -> orders off by two hours.
    When you are in the admin is the time and date correctly shown in the header?

    When you look at admin->version
    Is the "Server Date" and "Database Date" the same as each other?
    and are they correct?

    Quote Originally Posted by Woodymon View Post
    1. What does the Time Zone Offset entry in Admin >Config > MyStore suppose to do? Is that a stock zc 1.51 configuration entry? Or something leftover in the database from a previous time zone offset mod install (upgraded the zc db from 1.37 to 1.51)?

    I entered "-2" in the form but appears to not be doing anything. Within phpmyadmin I don't see any function associated with that entry in the configuration table.
    This is leftover from the previous "Time Zone Offset" mod. It does nothing. It can stay there without affecting anything.

    Quote Originally Posted by Woodymon View Post
    2. query_factory.php Line 71 shows the following code. What is the function of "-2" in that line? Is that a hardcoded offset? Pretty certain this is the stock zc1.51 file.

    Code:
    if (getenv('TZ') && !defined('DISABLE_MYSQL_TZ_SET'))  @mysql_query("SET time_zone = '" . substr_replace(date("O"),":",-2,0) .  "'", $this->link);
    This converts the system php date() (which has to be correct first) into a form that is used to set the mysql time zone.

  2. #72
    Join Date
    Sep 2004
    Posts
    2,420
    Plugin Contributions
    2

    Default Re: Time Zone Fix Support Thread

    I spoke to soon. All timestamps are now in alignment and showing Pacific TZ. Thanks for the info Gilby.

  3. #73
    Join Date
    Apr 2012
    Posts
    127
    Plugin Contributions
    0

    Default Re: Time Zone Fix Support Thread

    Will this work fine for v1.5? I am in the PST/GMT-8 time and my shop is apparently 8 hours ahead of me (I guess that would make it GMT+0). I hope this mod will fix the fact that my sales always end 8 hours too early..?

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

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by meljen View Post
    Will this work fine for v1.5? I am in the PST/GMT-8 time and my shop is apparently 8 hours ahead of me (I guess that would make it GMT+0). I hope this mod will fix the fact that my sales always end 8 hours too early..?
    See Posts 64 and 65
    The query factory part is built in to 1.5.0 and 1.5.1
    DON'T upload that file of this mod.

    The "other" 2 files with the TZ variables are what you need.

  5. #75
    Join Date
    Jun 2013
    Location
    Melbourne, Australia
    Posts
    12
    Plugin Contributions
    0

    Default Re: Time Zone Fix Support Thread

    I was looking for an update to this file. Have since discovered that with version 1.5.4 + of Zen Cart to make you zone the one where you are situated (and not where your site server is located) the solution is simple. For earlier versions still look at this line:

    https://www.zen-cart.com/showthread....2Btime+%2Bzone

    As mentioned I am using 1.5.4, so all I needed to do was:

    a) Open /includes/extra_configures/set_time_zone.php
    b) Go to the following line:
    c) $TZ = ‘’; // eg: ‘Europe/Oslo’
    d) Change to:
    e) $TZ = ‘Australia/Melbourne’; // eg.’Europe/Oslo’
    f) Upload the file

    Use the following to find you location:

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

    I hope this saves at least one person a lot of time!

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

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by anthonyh View Post
    I was looking for an update to this file. Have since discovered that with version 1.5.4 + of Zen Cart to make you zone the one where you are situated (and not where your site server is located) the solution is simple. For earlier versions still look at this line:

    https://www.zen-cart.com/showthread....2Btime+%2Bzone

    As mentioned I am using 1.5.4, so all I needed to do was:

    a) Open /includes/extra_configures/set_time_zone.php
    b) Go to the following line:
    c) $TZ = ‘’; // eg: ‘Europe/Oslo’
    d) Change to:
    e) $TZ = ‘Australia/Melbourne’; // eg.’Europe/Oslo’
    f) Upload the file

    Use the following to find you location:

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

    I hope this saves at least one person a lot of time!
    With Zen v1.5.4
    Be sure that you don't alter the admin side files (because that set_time_zone.php file is automatically used by both the admin and non-admin).

  7. #77
    Join Date
    Aug 2005
    Location
    San Juan, Puerto Rico
    Posts
    1,525
    Plugin Contributions
    9

    Default Re: Time Zone Fix Support Thread

    After doing this fix the invoices and packing slips continue showing server time. Is there a way to solve this?
    IDEAS Girl
    IDEAS Creative Group
    = Your image... our business!
    My contributions: SophyBlue / Sophy Blue-Grey / Mistik / The Bookshelf / Dynamic Sideboxes

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

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by ideasgirl View Post
    After doing this fix the invoices and packing slips continue showing server time. Is there a way to solve this?
    What version of Zen-Cart?
    Which version of this mod?

    What does Admin-Version "Server Date" and "Database Date" show for the time? (They should be the same)
    What is shown in the Admin header for the date/time?
    These 3 should ALL show the new date and time

  9. #79
    Join Date
    Aug 2005
    Location
    San Juan, Puerto Rico
    Posts
    1,525
    Plugin Contributions
    9

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by gilby View Post
    What version of Zen-Cart?
    Which version of this mod?

    What does Admin-Version "Server Date" and "Database Date" show for the time? (They should be the same)
    What is shown in the Admin header for the date/time?
    These 3 should ALL show the new date and time
    ZC v1.5.1
    TimeFix: Latest

    Where do I see the "Database Date"? (Is that the one for example that shows on "date purchased"?)
    The admin header time shows the date/time of customer as wanted.

    When I do a backup with the MySql Backup it indicates the date/time correctly as the header.

    I will recheck the issue with the customer again, since I haven't got the confirmation yet that he continues having the issue.
    IDEAS Girl
    IDEAS Creative Group
    = Your image... our business!
    My contributions: SophyBlue / Sophy Blue-Grey / Mistik / The Bookshelf / Dynamic Sideboxes

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

    Default Re: Time Zone Fix Support Thread

    Quote Originally Posted by ideasgirl View Post
    ZC v1.5.1
    TimeFix: Latest

    Where do I see the "Database Date"? (Is that the one for example that shows on "date purchased"?)
    The admin header time shows the date/time of customer as wanted.

    When I do a backup with the MySql Backup it indicates the date/time correctly as the header.

    I will recheck the issue with the customer again, since I haven't got the confirmation yet that he continues having the issue.
    Admin->Version will show a line like

    Server Date: 07/05/2015 11:43:56 Database Date: 07/05/2015 11:43:56

    As the admin shows the correct date/time then we know that PHP has the correct time
    The core 1.5.1 code will take this and set the Database Time, (assuming you haven't altered the default query_factory.php)

    The mod won't fix any date/times on orders that are already in the database
    It will only "fix" new orders placed after the mod is added

 

 
Page 8 of 9 FirstFirst ... 6789 LastLast

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. Multiple Zone Rates Support Thread
    By totalsam in forum Addon Shipping Modules
    Replies: 54
    Last Post: 24 Feb 2015, 03:34 PM
  3. v150 Time Zone Fix
    By donscotti in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 4 Nov 2012, 07:09 PM
  4. 1064 Error after installing Time Zone Fix addon
    By HFProjekte in forum General Questions
    Replies: 3
    Last Post: 6 Aug 2011, 11:01 AM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR