Zen Cart Logo
Forums / Addon Shipping Modules / Time Zone Offset - Help!!!

Time Zone Offset - Help!!!

Locked

Views: 1,161

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
9 Dec 2008, 2:32 AM
#1
jenzi avatar

jenzi

Zen Follower

Join Date:
Jan 2007
Posts:
145
Plugin Contributions:
0

Time Zone Offset - Help!!!

I tried it out on my test store first and it installed OK... but I stupidly put in "+09,0" in the admin field and I broke the interface...

I am getting:
*
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 '0 HOUR), '1', 'configuration.php', 'gID=1&', '121.209.35.65')' at line 1
in:
[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (date_add(now(), INTERVAL +09,0 HOUR), '1', 'configuration.php', 'gID=1&', '121.209.35.65')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

*How can I get out of this? Thanks in advance!

9 Dec 2008, 5:11 AM
#2
jenzi avatar

jenzi

Zen Follower

Join Date:
Jan 2007
Posts:
145
Plugin Contributions:
0

Re: Time Zone Offset - Help!!!

Ok, I gathered from the time zone support thread that I need to use phpmyadmin to alter the invalid value in the database.

Can someone give me a starter on what to do exactly once I am in phpmyadmin? I have never used it to alter a value before...

9 Dec 2008, 5:20 AM
#3
jenzi avatar

jenzi

Zen Follower

Join Date:
Jan 2007
Posts:
145
Plugin Contributions:
0

Re: Time Zone Offset - Help!!!

I think I am talking to myself here. :laugh:

I found the table that I need to edit - and I can see the stupid value I entered... I have checked the box to the far left - can anyone tell me how I can get in there and edit it exactly?

Much obliged!

9 Dec 2008, 5:29 AM
#4
jenzi avatar

jenzi

Zen Follower

Join Date:
Jan 2007
Posts:
145
Plugin Contributions:
0

Re: Time Zone Offset - Help!!!

Lord almighty I fixed it myself!!!

I found the little edit button (hehe) - took a guess and deleted everything in the field and then hit "go". Realised I totally broke the zen admin panel in the process! I somehow got back into the table and inserted "0" and then hit go again. And it worked!

I am proud of myself!