UPS XML Rates and Services v1.0

[Barely Legal Welding]

I installed the UPS XML Rates and Services v1.0 module and when i try to edit an exsisting produt(product i have on the site dfore adding the shipping module) i get this error: 1054 - Unknown column 'products_length' in 'field list'

 

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, products_length, products_width, products_height, products_ready_to_ship, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '29' and p.products_id = pd.products_id and pd.language_id = '1'

 

any one have this same error? Or have any idea how to fix it?

If i add a new product i have no problems.

 

Thanks

Richie

[Jan Zonjee]

I installed the UPS XML Rates and Services v1.0 module and when i try to edit an exsisting produt(product i have on the site dfore adding the shipping module) i get this error: 1054 - Unknown column 'products_length' in 'field list'

Looks like you use the admin/categories.php you found somewhere in the package that is needed if you have all the bells and whistles for dimensional support installed. But then you also need to add those additional fields to the database for products_length, products_width etc. (sql file in the package). For the basic UPSXML you don't need to make any changes to admin files or the database (apart from adding the additional configuration values).