Guest Posted July 2, 2009 Posted July 2, 2009 I am getting this error when I try to add new product: 1054 - Unknown column 'products_height' in 'field list' insert into products (products_quantity, products_model, products_price, products_date_available, products_weight, products_height, products_length, products_width, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('1000', '2568147', '', null, '', '', '', '', '', '1', '0', '', 'LUPIC6_800.jpg', now()) [TEP STOP] How can I correct this? OSC V2.2rc2
♥ecartz Posted July 2, 2009 Posted July 2, 2009 Did you install a contribution to add product dimensions? If so, it looks like you missed the database changes. There should be a .sql file that says something like (INTs may be DECIMALs or something else instead) ALTER TABLE products ADD products_height INT(11) ADD products_length INT(11) ADD products_width INT(11) You need to run that file in something like phpMyAdmin. Always back up before making changes.
Guest Posted July 2, 2009 Posted July 2, 2009 Did you install a contribution to add product dimensions? If so, it looks like you missed the database changes. There should be a .sql file that says something like (INTs may be DECIMALs or something else instead) ALTER TABLE products ADD products_height INT(11) ADD products_length INT(11) ADD products_width INT(11) You need to run that file in something like phpMyAdmin. Thanks!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.