Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15
  1. #11
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: Time Zone Offset -- Fixing a SQL syntax error?

    Quote Originally Posted by schoolboy View Post
    +14 = -10
    +16 = -8

    You can't have >12 (+14 or +16) - there are only 24 hours in a day... 12 either side of GMT !
    12 hours either side adds up to 24 you are right

    But here in the colonies strange things happen

    Here in Oz we are GMT+10
    Our datacenter in the states is GMT-6
    So to offset our time from the datacentre is +16

    Back to school for the schoolboy

  2. #12
    Join Date
    Jan 2007
    Posts
    226
    Plugin Contributions
    0

    Default Re: Time Zone Offset -- Fixing a SQL syntax error?

    Hello,

    I think I actually had "+h13", and I guess having a letter in it was the thing that stuffed it up.

    Kind regards,
    Anthony

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

    Default Re: Time Zone Offset -- Fixing a SQL syntax error?

    Quote Originally Posted by xman888 View Post
    Hello,

    I think I actually had "+h13", and I guess having a letter in it was the thing that stuffed it up.

    Kind regards,
    Anthony
    That would certainly do it
    Glad you got it fixed

  4. #14
    Join Date
    Nov 2006
    Location
    Sydney, Australia
    Posts
    458
    Plugin Contributions
    1

    red flag Re: Time Zone Offset -- (NOT Changing in ADMIN Header after succefully installing)

    Hi All,

    I just had the same problem, figured it out at the end and added the correct time off set!

    The only problem is this Add-on doesn't seem to change the Admin Header Timezone, is that true??
    If it is not suppose to change that time, then how can I do that?

    Best Regards,

  5. #15
    Join Date
    Nov 2006
    Location
    Sydney, Australia
    Posts
    458
    Plugin Contributions
    1

    Default Re: Time Zone Offset -- (NOT Changing in ADMIN Header after succefully installing)

    Quote Originally Posted by rlexyd View Post
    Hi All,

    I just had the same problem, figured it out at the end and added the correct time off set!

    The only problem is this Add-on doesn't seem to change the Admin Header Timezone, is that true??
    If it is not suppose to change that time, then how can I do that?

    Best Regards,
    It's me again,

    Just figured it out... I needed to add one of the Optional Files that came with the add-on in admin/includes/extra_configures/time_offset.php and edit the file to my City. Works Great now!

    Cheers :)

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Replies: 1
    Last Post: 25 Aug 2011, 05:58 AM
  2. 1064 You have an error in your SQL syntax - Time Zone Offset
    By clipegg in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 28 Oct 2010, 04:37 AM
  3. Time Zone Offset Error
    By 10gallons in forum Basic Configuration
    Replies: 5
    Last Post: 5 Sep 2009, 02:51 AM
  4. Help Error after insert of SQL for time offset mod
    By wmorris in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 8 Nov 2008, 03:03 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