Individual Shipping FWR

[crittle]

I think I have messed up loading this contribution.

I followed the instructions, but I think I might of skipped this part which maybe

causing the error.

** Step 2 **

Using PHPmyadmin, or however you like to do it, run this SQL command on your database:

 

ALTER TABLE products ADD products_ship_price DECIMAL(15,4) NOT NULL;

 

Can someone enlighten me on what to do here, or how to fix this problem.

I am new at this so I'm learning as I go.

 

The website is www.junqueinthetrunk.com

 

Contribution:

http://www.oscommerce.com/community/contributions,1333

 

Error under admin in "catagories" section:

 

Categories / Products

Search:

Go To:

1054 - Unknown column 'p.products_ship_price' in 'field list'

 

select p.products_ship_price, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

 

[TEP STOP]

 

Error when you try to purchase something:

Sub-Total: 1054 - Unknown column 'products_ship_price' in 'field list'

 

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

 

[TEP STOP]

 

Error under the "buggie" button on right:

 

1054 - Unknown column 'products_ship_price' in 'field list'

 

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

 

[TEP STOP]

 

Is this an easy fix or do I just need to take the update out?

 

Also, I don't see a UPS option in my admin, do I have to add a contribution for this too?

 

Thanks!!

[crittle]

Nevermind, I figured it out. I had to go into the database which was seperate from my ftp site and there was a button there that said "sql", clicked on it, it gave me "Run SQL query/queries on database" and a little box below that. So I just pasted the code the "readme.txt" gave me from the contribution "ALTER TABLE products ADD products_ship_price DECIMAL(15,4) NOT NULL;" and hit "go". It works fine. Now I have to figure out how to get the individual shipping on the item. If I can figure this out, I should be able to figure out how to use the darn thing. :D