The Template Shop - eCommerce Software
eCommerce Templates
Open Source Shopping Cart Software
Customer Support Center
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

 This article was helpful  This article was not helpful

 Back
 Log in [Lost Password] 
E-mail:
Password:
Remember Me:
 
 Search
 Article Options