Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ERROR on new product upload


Guest

Recommended Posts

Posted

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

Posted

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.

Posted
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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...