Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    58
    Plugin Contributions
    0

    Default Editing products

    Hi there
    Can someone please help me I was trying to edit one my products today and when I click edit this message came up.

    1054 Unknown column 'p.products_height' 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_height,p.products_length, p.products_width, 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 from zen_products p, zen_products_description pd where p.products_id = '29' 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.


    I have looked at all the products and it is the same for all.

    When I created the information it was there to edit. The pages appear ok on the website itself.

    I have it set up as Categories/Subcategories/Products when I created the individual products.

    The only thing that I had adjusted prior was the image sizes in the configuration but I have changed them back to the defaults and I am still getting this.

    Thanks

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Editing products

    Details???

    Zen Cart Version
    Clean install or upgrade
    From what to what
    win or 'nix
    php ver
    mysql ver
    etc.
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Aug 2008
    Location
    Sydney Australia
    Posts
    58
    Plugin Contributions
    0

    Default Re: Editing products

    I've just notice this is a problem when the Australian Post Module has been loaded. I am going to sort that out for it to work right.

 

 

Similar Threads

  1. Disabled products show as new products after editing
    By krazykev in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 21 Feb 2009, 05:52 PM
  2. editing products page, empty
    By Dragonsfyre in forum Basic Configuration
    Replies: 2
    Last Post: 25 Mar 2008, 02:35 PM
  3. Editing Featured Products
    By devon789456316541560 in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 6 Jul 2007, 06:08 AM

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