Forums / General Questions / Error 1054 Unknown column 'p.products_condition'

Error 1054 Unknown column 'p.products_condition'

Locked

Views: 892

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
28 Jun 2010, 4:29 PM
#1
rxalex avatar

rxalex

Totally Zenned

Join Date:
Feb 2006
Posts:
588
Plugin Contributions:
0

Error 1054 Unknown column 'p.products_condition'

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?

28 Jun 2010, 10:34 PM
#2
tinas avatar

tinas

Totally Zenned

Join Date:
Jan 2005
Location:
Lake Havasu, AZ
Posts:
1,090
Plugin Contributions:
0

Re: Error 1054 Unknown column 'p.products_condition'

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

When the world gets in my face I say Have A Nice Day.

29 Jun 2010, 1:52 AM
#3
rxalex avatar

rxalex

Totally Zenned

Join Date:
Feb 2006
Posts:
588
Plugin Contributions:
0

Re: Error 1054 Unknown column 'p.products_condition'

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