Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    6
    Plugin Contributions
    0

    Default UNDO patch? timezone offset mod

    Hi, yesterday I installed the time offset module, it didn't work with my settings (Zen Cart 1.3.0.1 Database Patch Level: 1.3.0.1) for whatever reasons in a number of areas (mostly new account creation), by the time we did all the testing on this we had lots of orders come in, so I've restored all my old files but not the database back up and would like to avoid it. Is there anyway to "undo" the patch with another patch??

    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Time Zone Offset', 'TIME_ZONE_OFFSET', '0', 'The time zone difference between your store and the server. Enter +h, 0 or -h where ''h'' is the number of hours. If your store time zone is ahead of the server time zone, use +', 1, 7, NULL, '0001-01-01 00:00:00', NULL, NULL);

    Thanks!

  2. #2
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: UNDO patch?

    If that's the only SQL change you made, then you can remove it by running this in the Install SQL Patch tool:

    Code:
    delete from configuration where configuration_key = 'TIME_ZONE_OFFSET';
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    May 2006
    Posts
    6
    Plugin Contributions
    0

    red flag Re: UNDO patch? timezone offset mod

    Thank you so much for that info, this is a great community.

    The owner said he made some changes to the zones and shipping, but that everything seems to be working okay now (still could find out differently) and we might as well 'leave well enough alone' if so . . .

    does anyone think that patch that changed the database config for the timezone offset will do any harm if the timezone offset is not being used?

    Thanks!

  4. #4
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: UNDO patch? timezone offset mod

    Quote Originally Posted by webthingz View Post
    does anyone think that patch that changed the database config for the timezone offset will do any harm if the timezone offset is not being used?
    No harm done.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. Sidebar Mod Undo - Help!
    By Lovely in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 13 Sep 2008, 10:22 PM
  2. Timezone Offset
    By trappersam in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 18 Oct 2007, 04:43 PM
  3. Timezone offset not correct
    By Goshawk in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 11 Jan 2007, 02:26 PM
  4. Timezone Offset updated 1.3.0 error
    By jetx in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 15 May 2006, 06:34 AM

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