1054 Unknown Column

[Guest]

My server recently upgraded to Mysql 5. Apparently it created problems with OSCommerce 2.3.1 already installed. When I try to add a product I get the following error. I believe there is also an issue with ordering. Any suggestions on a fix or should I uninstall and reinstall?

 

1054 - Unknown column 'products_height' in 'field list'

 

insert into products (products_quantity, products_model, products_price, products_date_available, products_height, products_length, products_width, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id, products_weight, products_date_added) values ('0', 'test1', '.1', null, '1', '1', '4', '', '1', '1', '11', '1', now())

 

[TEP STOP]

 

Thanks.

[Guest]

Carson,

 

 

The server update had nothing to do with the error. 'products_height' is not a standard field in the products table so you must have added a contribution without running the provided database changes.

 

 

 

Chris