1054 Unknown column 'p.products_sell_quantity' in 'field list'
Hi
I keep getting this error that says
1054 Unknown column 'p.products_sell_quantity' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id, p.products_sell_quantity, p.products_less_quantity, p.products_coupon from zen_products p, zen_products_description pd where p.products_id = '8' and p.products_id = pd.products_id and pd.language_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Re: 1054 Unknown column 'p.products_sell_quantity' in 'field list'
There is a mod called "Buy one Get one free" that uses this field. You need to run the sql script to create the database fields as part of the installation of this mod.