Time Zone Offset - Help!!!

[jenzi]

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!

[jenzi]

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...

[jenzi]

I think I am talking to myself here.

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!

[jenzi]

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!