storeweb88 Posted June 28, 2010 Posted June 28, 2010 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?
storeweb88 Posted June 28, 2010 Author Posted June 28, 2010 ok i have recently added in ups and usps mods... maybe that has something.. im not sure how to fix though still...
storeweb88 Posted June 28, 2010 Author Posted June 28, 2010 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) );
Recommended Posts
Archived
This topic is now archived and is closed to further replies.