CMS MADE SIMPLE FORGE

Orders

 
Back Back to List

[#4784] module.upgrade.php for 1.7.1 fails to add the "sku" field

avatar
Created By: Kenneth Griffith (kendo451)
Date Submitted: Tue Apr 13 18:36:00 -0400 2010

Assigned To:
Version: 1.7.1
CMSMS Version: None
Severity: Major
Resolution: None
State: Open
Summary:
module.upgrade.php for 1.7.1 fails to add the "sku" field
Detailed Description:
1.7.1 has a new field, "sku".  However, the module.upgrade.php does not update
the tables to add this field.  So when you upgrade an existing Orders
installation and then add an actual order it chokes with this error:

DEBUG: INSERT INTO cms_module_orders_items
(order_id,shipping_id,item_id,quantity,
product_name,details,unit_price,discount,weight,status,
create_date,modified_date,item_type,sku) VALUES (45,50,4,1,'One Year Membership
(Fall - Spring) in CAGT ',NULL,'75',NULL,'0','notshipped','2010-04-13
13:39:45','2010-04-13 13:39:45','0_product',NULL)
Unknown column 'sku' in 'field list'


History