Discount coupon Error

**lucky__starre** · 17 Apr 2007, 01:46 AM

Going to the coupon admin area I get the following error at the top of the screen:

1054 Unknown column 'coupon_zone_restriction' in 'field list'
in:
[select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_p roducts, restrict_to_categories, date_created,date_modified, coupon_active, coupon_zone_restriction from coupons where coupon_type != 'G' limit 0, 20]
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 didn't have any coupons set up as yet, any ideas?

Thanks
Katie
www.live2knit.com.au

**Ajeh** · 17 Apr 2007, 01:47 AM

Sounds like you did an Upgrade and did not Upgrade your database tables ...

How did you do the upgrade?

**lucky__starre** · 17 Apr 2007, 01:53 AM

I had some problems upgrading to 1.3.7.
I uploaded all the new & changed files but didn't actually run the upgrade as such, my store seems to be running OK & this is the first issue I've had.

Katie
www.live2knit.com.au

**Ajeh** · 17 Apr 2007, 02:04 AM

Each release of Zen Cart needs to have a backup of both the site and database and then upload the files *and* run the /zc_install to upgrade the database ...

There are lots of things that get updated in an Upgrade and if you only do it half way ... well, umm ... there is a term about having it done half ... umm ... you know ...