Looking for the v10 manual? Visit our new user's guide!
 
Search Descriptions Version
 
 
This article applies to: ML8

Invalid column name 'CouponProductIDs' or 'NotValidForProducts' or 'ExcludeSaleProduct' or 'ReceiptHtml'


Symptoms
When attempting to checkout after upgrading from a previous edition (5x/6x/7x) to edition ML8.0.1.4 or 8.1.0.0, you receive one of these errors.

Cause
5x/6x/7x "upgrade to latest" scripts do not have the changes required for the new coupon functionality.

Solution
First, backup your database (contact your database administrator if you do not have access or knowledge to do this).

Second, run the following script against your database. You can also do this by going into your Admin console, go to Configuration > Advanced > Run SQL and copy paste the script below in the window, then press Submit.

if not exists (select * From syscolumns where id = object_id('Coupon') and name = 'NotValidForProducts')
begin
ALTER TABLE [dbo].Coupon ADD NotValidForProducts ntext
end
if not exists (select * From syscolumns where id = object_id('Coupon') and name = 'ExcludeSaleProduct')
begin
ALTER TABLE [dbo].Coupon ADD ExcludeSaleProduct tinyint default(0)
end
if not exists (select * From syscolumns where id = object_id('Orders') and name = 'CouponProductIDs')
begin
ALTER TABLE [dbo].Orders ADD CouponProductIDs varchar(1024)
end
if not exists (select * From syscolumns where id = object_id('Orders') and name = 'ReceiptHtml')
begin
ALTER TABLE [dbo].Orders ADD ReceiptHtml ntext
end