Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error - 1054 - Unknown column 'products_height' in


storeweb88

Recommended Posts

Posted

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 ('1', '1', '0.01', null, '1', '', '', '', '', '1', '1', '0', 'cat5 cable.jpg', now())

 

[TEP STOP]

 

 

- thats the error I am getting when i go to insert in the admin.. I am not sure why I am getting it??? Any pointers?

Posted

Ok after reading around some.. I found it was when I didn't install the sql tables for upsxml thingy plugin...

 

ALTER TABLE products

ADD products_length DECIMAL(6,2) DEFAULT '12' NOT NULL,

ADD products_width DECIMAL(6,2) DEFAULT '12' NOT NULL,

ADD products_height DECIMAL(6,2) DEFAULT '12' NOT NULL,

ADD products_ready_to_ship INT(1) DEFAULT '0' NOT NULL;

 

DROP TABLE IF EXISTS packaging;

CREATE TABLE packaging (

package_id int NOT NULL auto_increment,

package_name varchar(64) NOT NULL,

package_description varchar(255) NOT NULL,

package_length DECIMAL(6,2) default '5' NOT NULL,

package_width DECIMAL(6,2) default '5' NOT NULL,

package_height DECIMAL(6,2) default '5' NOT NULL,

package_empty_weight DECIMAL(6,2) DEFAULT '0' NOT NULL,

package_max_weight DECIMAL(6,2) DEFAULT '50' NOT NULL,

package_cost int(5) NOT NULL,

PRIMARY KEY (package_id)

);

Archived

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

×
×
  • Create New...