Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PayPal add on has an extra field.


darp

Recommended Posts

I am installing the PayPal Website Payments Pro. In the product_info.php file there is a query. Among other fields the query which includes a 'product_type' field. However there is no 'product_type' field in the products table, so I get an error ever time I select a product.

 

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

 

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_type from products p, products_description pd where p.products_status = '1' and p.products_id = '207' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

The original file does not have 'product_type', however the add on from PayPal and the add on from OSC have it. Did I miss something. Was there an update that added this field? How do I fix this? Is it OK to just add the field to the db?

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...