MySQL error: 1054 - Unknown column 'coupon_sale

05 Sep 2010

Support Center » Knowledgebase » MySQL error: 1054 - Unknown column 'coupon_sale_exclude' in 'field list'

	MySQL error: 1054 - Unknown column 'coupon_sale_exclude' in 'field list'

Solution Question:
I finally installed and upgraded my website. Everything works perfactly except for the checkout_confirmation.php. the following error occurs:

Error reported on page /catalog_new/catalog/checkout_confirmation.php

MySQL error: 1054 - Unknown column 'coupon_sale_exclude' in 'field list'

select coupon_amount, coupon_minimum_order, restrict_to_products, restrict_to_categories, coupon_type,coupon_sale_exclude from coupons where coupon_id = '0'

can someone please help me? Thanks!

Answer:
You need to add the missing column to the coupons table in your database via phpMyAdmin to correct the error:

ALTER TABLE coupons ADD COLUMN coupon_sale_exclude char(1) NOT NULL default '0' AFTER coupon_type;

Article Details

Article ID:

355

Created On:

24 Feb 2009 03:22 AM