Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Adding Attribute to product Problem after upgrade

Adding Attribute to product Problem after upgrade

Locked

Views: 1,487

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
19 Nov 2007, 4:07 PM
#1
darkmuncan avatar

darkmuncan

New Zenner

Join Date:
Aug 2005
Posts:
33
Plugin Contributions:
0

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.

19 Nov 2007, 4:30 PM
#2
darkmuncan avatar

darkmuncan

New Zenner

Join Date:
Aug 2005
Posts:
33
Plugin Contributions:
0

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.