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
[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.
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.
By davale in forum Templates, Stylesheets, Page Layout
Last Post: 19 Oct 2007, 06:19 AM
By Shiftypow in forum Basic Configuration
Last Post: 4 Jun 2007, 07:20 AM
By momopopo in forum Setting Up Categories, Products, Attributes
Last Post: 6 Jul 2006, 05:12 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC