1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'

Hi

I'm not sure if this is the correct forum to post this...

I have setup my Zen Cart to require authorisation before a customer can view the products, and after creating a test account, I get this error when I try to log on:

1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'
in:
[UPDATE customers_info SET customers_info_date_of_last_logon = date_add(now(), INTERVAL TIME_ZONE_OFFSET HOUR), customers_info_number_of_logons = customers_info_number_of_logons+1 WHERE customers_info_id = 1]

I'm not sure why it is doing this... the account has been set to authorised and if I go back to the previous page on my browser (or any other for that matter), the site works fine.

Any idea how I can fix this error?

Thanks,
Tija

You've partially installed the Time Zone Offset addon, but not completely.
You've missed at least the SQL portion of the installation. Maybe more.
It has nothing to do with customer authorizations.

Thanks DrByte.

We duplicated this error site from another one of ours, and we now realise that the original must have had a Time Zone OFfset addon - we haven't installed the addon on the site with the error.

Will installing the addon fix this error?

Thanks again,
Tija

OK - I installed the addon and the error no longer occurs.

Thanks again :)

• Tija