Shopping Cart and 1054 error

[joncampbell]

OK, here's the problem:

 

I've got a mainly stock, freshly installed store (only main addition is the Canada Post shipping module)

 

trouble is, every time a customer logs in or trys to view their shopping cart I only get the following error:

 

1054 - Unknown column 'p.products_dim_type' in 'field list'

 

select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_tax_class_id from products p, products_description pd where p.products_id = '28' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

 

any clues?

[jennki]

OK, here's the problem:

 

I've got a mainly stock, freshly installed store (only main addition is the Canada Post shipping module)

 

trouble is, every time a customer logs in or trys to view their shopping cart I only get the following error:

 

1054 - Unknown column 'p.products_dim_type' in 'field list'

 

select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_tax_class_id from products p, products_description pd where p.products_id = '28' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

 

any clues?

 

Check this out, may help.

http://www.oscommerce.com/forums/index.php?showtopic=186179