1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'

[MortalWombat]

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

[DrByte]

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.

[MortalWombat]

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

[MortalWombat]

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

Thanks again :)

- Tija