New Shipping Module errors

[Guest]

I recently installed the contribution by thunderrace because I had a product that required its own individual shipping price. I followed the install instructions and now have the following error:

 

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]

 

I am not sure how to enter the SQL command called for in the docs which I think may be causing the error.

"run this SQL command on your database: ALTER TABLE products ADD products_ship_price DECIMAL(15,4) NOT NULL;"

I use putty to access my mysql database

 

 

 

Any help? Anyone?

[Guest]

I recently installed the contribution by thunderrace because I had a product that required its own individual shipping price. I followed the install instructions and now have the following error:

 

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]

 

I am not sure how to enter the SQL command called for in the docs which I think may be causing the error.

"run this SQL command on your database: ALTER TABLE products ADD products_ship_price DECIMAL(15,4) NOT NULL;"

I use putty to access my mysql database

Any help? Anyone?

 

I now know why i received the above error and added the mysql line in the database. The problem now is since php 4 or greater requires registered globals off, since I added the registered global patch, the contrib above cannot work because it requires registered globals on. Does anyone know of a shipping module that will work with registered globals off?