Forums / General Questions / 1054 Unknown column 'p.products_condition' in 'field list'

1054 Unknown column 'p.products_condition' in 'field list'

Locked

Views: 1,416

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

rxalex

Totally Zenned

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

1054 Unknown column 'p.products_condition' in 'field list'

I got this error in zencart version 1.3.9d when I try 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.

whats the cause and how can I fix this?

29 Jun 2010, 2:37 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 1054 Unknown column 'p.products_condition' in 'field list'

products_condition is not a field in the default Zen Cart tables ...

Are you missing an add on or missed an update on merging files?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

29 Jun 2010, 2:41 PM
#3
rxalex avatar

rxalex

Totally Zenned

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

Re: 1054 Unknown column 'p.products_condition' in 'field list'

Thanks Linda, I needed to re-install the sql file for product fields.