20 Feb 2009, 12:09 AM
New Zenner
- Join Date:
- May 2007
- Location:
- Melbourne, Australia
- Posts:
- 88
- Plugin Contributions:
- 0
Zone definition error for zencart 1.3.7
Hi People,
I'm using zencart 1.3.7 on a zeus-linux server
I recently noticed that my direct bank payments module no longer differentiated for different zones. Normally I just have direct payments for Australian users. I'm finding that the module no longer allows me to specify a zone.
Searching around I discovered that when I click on locations/taxes>Zone definitions that I'm getting the following error:
1054 Unknown column 'date_added' in 'field list'
in:
[select geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added from geo_zones order by geo_zone_name limit 0, 20]
And there are no zones shown. What does this mean and how do I fix it?