Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    588
    Plugin Contributions
    0

    Default 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?

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  3. #3
    Join Date
    Feb 2006
    Posts
    588
    Plugin Contributions
    0

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

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

 

 

Similar Threads

  1. 1054 Unknown column 'COWOA_order' in 'field list'
    By willieWontGo in forum PayPal Express Checkout support
    Replies: 9
    Last Post: 1 Jul 2011, 08:18 PM
  2. 1054 Unknown column 'p.products_carrot' in 'field list'
    By vivianso in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 23 Jun 2011, 05:25 PM
  3. Error 1054 Unknown column 'p.products_condition'
    By rxalex in forum General Questions
    Replies: 2
    Last Post: 29 Jun 2010, 02:52 AM
  4. 1054 Unknown column 'products_prid' in field list
    By luckykat in forum General Questions
    Replies: 1
    Last Post: 21 May 2006, 01:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR