Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    5
    Plugin Contributions
    0

    Default can't edit my products

    Hi all,
    When I add a new product to my shop and when I want to edit that product I receive this error:

    Error number: 1054 :: Unknown column 'pd.description_categories_id' in 'field list'
    when loading:
    [select pd.products_name, pd.products_description, pd.products_url, pd.description_categories_id, 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 from products p, products_description pd where p.products_id = '104' and p.products_id = pd.products_id and pd.language_id = '1']
    If you see this error it means that is a data base error. Try to refresh you page.

    Have you got any solutions to fix that? It's very importat to me to edit my products.

    Kind regards

    intrium.

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

    Default Re: can't edit my products

    Sounds like you have a faulty install on an add-on or bad code in the add-on ... where does the field:
    description_categories_id

    come from?
    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!

 

 

Similar Threads

  1. Can't seem to edit new products?
    By wizer in forum Customization from the Admin
    Replies: 6
    Last Post: 6 Jul 2011, 10:03 AM
  2. Can't seem to edit products
    By GigiCS in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 11 May 2011, 01:34 AM
  3. Can't edit products
    By stevensmedia in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 4 May 2011, 08:57 PM
  4. suddenly can't edit products
    By MZM in forum General Questions
    Replies: 3
    Last Post: 19 Sep 2007, 04:49 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