Disaster=>1054 - Unknown column

[Guest]

Hi, I'm having a bit of a problem with the cart. When I try to click on an item I get the following message on the right side of the page:: 1054 - Unknown column 'products_ship_price_two' in 'field list'

 

select products_id, products_price, products_ship_price, products_ship_price_two, products_tax_class_id, products_weight from products where products_id = '128'

 

[TEP STOP]

 

I installed the individual shipping prices mod and ever since have been getting this one. Can anyone offer guidance. I am really in the dark when it comes to php and mysql

 

The cart is located at https://host369.ipowerweb.com/~buckysco/osC...55b34f20feeb4bb

Anything anyone can do to help would be greatly appreciated.

[241]

you are missing a field from the database table products the field is called products_ship_price_two

 

go back over the install instructions to see if you can find the sql statement which adds this field to the database, failing this you may be able to copy the field products_ship_price to create a new field named products_ship_price_two

[Guest]

you are missing a field from the database table products the field is called products_ship_price_two

 

go back over the install instructions to see if you can find the sql statement which adds this field to the database, failing this you may be able to copy the field products_ship_price to create a new field named products_ship_price_two

Okay-I couldn't find the statement for products_ship_price_two but the one I did install was products_ship_price . Should I add _two to the end of the statement and run it?

[241]

run this sql

 

ALTER TABLE products ADD products_ship_price_two VARCHAR( 10 ) DEFAULT NULL AFTER products_ship_price;

 

or this depending on whether product_shipping_prive is using varchar or decimal

 

ALTER TABLE products ADD products_ship_price_two DECIMAL( 15,4 ) DEFAULT NULL AFTER products_ship_price;

 

if decimal then alter the 15,4 to whatever values are shown for products_ship_price

[Guest]

run this sql

 

ALTER TABLE products ADD products_ship_price_two VARCHAR( 10 ) DEFAULT NULL AFTER products_ship_price;

 

or this depending on whether product_shipping_prive is using varchar or decimal

 

ALTER TABLE products ADD products_ship_price_two DECIMAL( 15,4 ) DEFAULT NULL AFTER products_ship_price;

 

if decimal then alter the 15,4 to whatever values are shown for products_ship_price

Thank you ever so much-I can breathe again. :thumbsup: I ran the query ALTER TABLE products ADD products_ship_price_two DECIMAL(15,4) NOT NULL; and it made the message go away, Thanx so much. Dave