Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    35
    Plugin Contributions
    0

    Default Adding Attribute to product Problem after upgrade

    After upgrading to 1.3.7 I have had a problem adding a created attribute option/value to a give product. Now under Attribute Controller after selecting attribute name/value and other options when I submit the information to add it to the product I get this message:

    "1136 Column count doesn't match value count at row 1
    in:
    [insert into zen_products_attributes values (0, '911', '7', '61', '0', '+', '0', '1', '0', '+', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', 'NULL', 'NULL', '0', '0', '0', '0', '0')]
    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."

    Can someone give me an idea of what's going on here and how I can fix it? It's very inconvenient to not be able to add new attributes.

  2. #2
    Join Date
    Aug 2005
    Posts
    35
    Plugin Contributions
    0

    Default Re: Adding Attribute to product Problem after upgrade

    Ok, if I had done a little better searching through forum threads I would have found that that others have experienced this. Apparently the fix for me was to remove a column from the zen_products_attributes table which was left over from an old add-on. Kudos to Wicked Klown for his suggested fix.

 

 

Similar Threads

  1. Adding custom field from specials table to product listing and product info
    By davale in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 19 Oct 2007, 06:19 AM
  2. Help making Template
    By Shiftypow in forum Basic Configuration
    Replies: 8
    Last Post: 4 Jun 2007, 07:20 AM
  3. SQL problem: How to retreive Attributes for a product ordered.
    By momopopo in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 6 Jul 2006, 05:12 PM

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
  •