Time Zone Offset -- Fixing a SQL syntax error?

[xman888]

Hello,

How do you go about fixing an SQL syntax error.

After I installed the time zone offset mod, I get this error when I try to log into my admin:


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13 HOUR), '1', 'configuration.php', 'gID=5&', '121.79.14.170')' at line 1
in:
[insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (date_add(now(), INTERVAL +h 13 HOUR), '1', 'configuration.php', 'gID=5&', '121.79.14.170')]

This is on zen 1.38 using the latest time zone offset mod.

Is there somethingin that error message that would show someone how to fix ths issue?

Any help would be greatly appreciated.

Kind regards,
Anthony

[kobra]

When, where and doing what do you see this error

Or a link to it

[xman888]

Hello Kobra,

Logging into my admin (ie. before even being able to enter in my username and password).

It occurs at this link:

http://www.xmanhosting.com.au/shop/admin

It occurred after I entered in a value in admin --> config --> time zone offset.

I haven't been able to use it since.

Would be easier to just uninstall the time zone mod? If so, how would one go about this?

Thanks for your time.

KInd regards,
Anthony

[kobra]

It occurred after I entered in a value in admin --> config --> time zone offset.

What value did you enter???

It looks like you might have entered "13"

13 HOUR), '0', 'login.php ', '', '76.25.247.55')' at line 1

Where the allowable values defined by

Enter +h, 0 or -h where ''h'' is the number of hours.

would be maxed at +12 or -12 and a 13 would probably cause a math error

If you use phpmyadmin and edit the configuration table or export it edit and re-insert/import it

look for 'TIME_ZONE_OFFSET'

Always backup before making any DB alterations....

[xman888]

Hi Kobra,

I think I did enter in "13" now that you mention it

I'll have a go with your recommendations and i'll see how I go.

Thanks for your help.

Kind regards,
Anthony

[Lafferty Store]

Hello,

How do you go about fixing an SQL syntax error.

After I installed the time zone offset mod, I get this error when I try to log into my admin:


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13 HOUR), '1', 'configuration.php', 'gID=5&', '121.79.14.170')' at line 1
in:
[insert into zen_admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (date_add(now(), INTERVAL +h 13 HOUR), '1', 'configuration.php', 'gID=5&', '121.79.14.170')]

This is on zen 1.38 using the latest time zone offset mod.

Is there somethingin that error message that would show someone how to fix ths issue?

Any help would be greatly appreciated.

Kind regards,
Anthony

I had the same exact problem. I battled with it for over an hour, getting the warnings in my admin cp, and every time I set the offset to match what the warning was telling me, the warning went 5 hours the other way. So I left it blank and got that very same error as you so I gave up and uninstalled the whole mess. (And my time is still off by 5 hours)

[xman888]

Hello Kobra,

Thanks for that - it worked a treat.

I just exported the configuration table, then modified the Time Zone Offset part of it, then deleted the configuration table, then imported the newly saved configuration table.

Thank you very much for that.

Kind regards,
Anthony

[kobra]

I just exported the configuration table, then modified the Time Zone Offset part of it, then deleted the configuration table, then imported the newly saved configuration table.

Just a footnote to this: Time is plus GMT or minus GMT and the MAX offset is 12

[gilby]

Just a footnote to this: Time is plus GMT or minus GMT and the MAX offset is 12

It can be more than this
In Oz I run all my sites between +14 and +16 depending on daylight saving here and in the datacentre.

If you use anything except a + or - prefix followed by a whole number it will crash.
A quoted value "13" or a value like 13:00 will crash it

[schoolboy]

It can be more than this
In Oz I run all my sites between +14 and +16 depending on daylight saving here and in the datacentre.

+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 !