darp Posted June 2, 2011 Share Posted June 2, 2011 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.