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

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

  2. #2
    Join Date
    Dec 2010
    Location
    NYC
    Posts
    101
    Plugin Contributions
    4

    Default Re: Error

    I have received the same error... I am copying a site and its contents to a new site - to a clean database ... I could just port over the old database as well and revise the configure.php files accordingly, however, I am up for the challenge here.. I used Easy Populate to populate the products... however, I need to manually adjust the attributes from new... How do I insert these fields into the database?

    Please advise,

    Eran

  3. #3
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,622
    Plugin Contributions
    123

    Default 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.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 

Similar Threads

  1. Urgent HELP needed, please! 1054 Unknown column 'products_sell_quantity'
    By gizmo_girl in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 17 Oct 2011, 01:00 AM
  2. 1054 Unknown column 'order_delivery_date' in 'field list'
    By cjacin75 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 12 Apr 2010, 03:48 AM
  3. 1054 Unknown column 'c.customers_referral' in 'field list'
    By helpme in forum General Questions
    Replies: 1
    Last Post: 23 Jul 2009, 05:47 PM
  4. 1054 Unknown column 'products_cost' in 'field list'
    By wowemall in forum General Questions
    Replies: 2
    Last Post: 29 Mar 2008, 07:07 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