Error 1054 Unknown column 'p.products_condition'

[rxalex]

I get this error when I am trying to edit a product.

1054 Unknown column 'p.products_condition' 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_condition, p.products_EHF, p.products_ebid, p.products_sh_na, p.products_sh_sa, p.products_sh_eu, p.products_sh_as, p.products_sh_af, p.products_sh_au, p.products_upc, p.products_isbn, p.products_ean, p.products_asin, p.products_epier, p.products_barcode, p.products_diameter, p.products_weight_type, p.products_dim_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_actual_weight, p.products_ebay from products p, products_description pd where p.products_id = '48' 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.

How do I fix this issue?

[TinaS]

That field selection has a LOT of custom fields in it that are not default with zen. It appears that you did not set up your tables correctly for using such custom fields.

Hope that helps

[rxalex]

Thanks, that helped. Installed the sql file for those fields again..