MySQL error: 1054 - Unknown column 'coupon_sale

	eCommerce Templates CRE Loaded \| Magento \| eCart ™ Open Source Shopping Cart Software
Home \| Register \| Submit a Ticket \| Knowledgebase \| News

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

Article 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:

146

Created On:

31 Dec 2009 10:19 PM