Forums / Managing Customers and Orders / 1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'

1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'

Locked

Started by mortalwombat on 24 Jul 2010, 5:58 AM · Views: 1,059

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
24 Jul 2010, 5:58 AM
#1
mortalwombat avatar

mortalwombat

Zen Follower

Join Date:
Jul 2010
Location:
Australia
Posts:
131
Plugin Contributions:
0

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

24 Jul 2010, 6:10 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: 1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

24 Jul 2010, 8:43 AM
#3
mortalwombat avatar

mortalwombat

Zen Follower

Join Date:
Jul 2010
Location:
Australia
Posts:
131
Plugin Contributions:
0

Re: 1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'

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

24 Jul 2010, 9:37 AM
#4
mortalwombat avatar

mortalwombat

Zen Follower

Join Date:
Jul 2010
Location:
Australia
Posts:
131
Plugin Contributions:
0

Re: 1054 Unknown column 'TIME_ZONE_OFFSET' in 'field list'

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

Thanks again :)

  • Tija