1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'

Hi,
i got this message:

1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'
in:
[select date_add(now(), INTERVAL TIME_ZONE_OFFSET HOUR) as date]
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.

and now cant even get into my admin area.

i restored my backup files for this mod and have deleted the the time zone offset in sql after i got this message and its still showing and i still cant get into the store admin.

can someone pleassssssssse help me?

If you have attempted to delete the module, then you need to put back all the original versions of the files affected by the time zone module.

Or, you need to fully re-install the module including its SQL.

Hello!
Thanks so much for your reply!
I deleted all the affected files and its sql and restored it with the original files.

After your reply, I have now reinstalled the time zone module and manually inserted the sql file via my host panel. The admin section of the online shop showed up for 2 secs... happy for the 2 secs... then i get a new error :cry:

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 ') , '1', 'configuration.php', 'gID=1&cID=1098&', ' {my IP Address} ' at line 1
in:
[insert into zen_admin_activity_log (acess_date, admin_id, page_accessed, page_parameters, ip_address) values (date_add(now(), INTERVAL HOUR), '1', 'configuration.php', 'gID=1&cID=1098&', ' {my IP Address} ']
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.

i refreshed that above page and got the message below. then i inserted the above items into zen_admin_activity_log via the host sql panel and still get:

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 ') as date' at line 1
in:
[select date_add(now(), INTERVAL HOUR) as date]
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.

the date i have added for zen_admin_activity_log and zen_configuration (aka time zone module) is 2008-04-20 20:24:11

please help! :frusty:

It was fixed.
after the last error mentioned above and insert, i uploaded the original backup files and now all was working fine and even better.

And thanks for your earlier reply Dr Byte! :smile: