Attributes error

[vivaraquel]

I have followed the instrucutions set by Ajeh on the help page under the "Hoe do I add attributes to my priducts questions" I've done it all as it said and I get this when I hit the insert button:
1136 Column count doesn't match value count at row 1
in:
[insert into zen_products_attributes values (0, '241', '1', '5', '0.15', '+', '0', '1', '0', '+', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', '', '', '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.

What does it mean and how do I fix it. Also, I feel the tutorial lacks some info. For exmplae, what is the "Attributes Qty Price Discount:" on the attributes controller page used for? Is it so that I can set price discounts as in the Product Price Manager?

If so how do I use it?

Thank you.

[vivaraquel]

Just go to this link, it'll fix it.

http://www.zen-cart.com/forum/showth...t=Column+count

[jenbullfrog]

Did anyone ever find out how to fix this error? I get the same thing when I try to add attributes to an item.
http://www.zen-cart.com/forum/showthread.php?t=65898

[p137]

I'm getting a similar error message:

1136 Column count doesn't match value count at row 1
in:
[insert into products_attributes values (0, '193', '5', '81', '0', '+', '5', '1', '0', '+', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '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.




thanks to anyone who can help!
-meg

[canemasters]

Did you get this figured out? I'm having the same problem after installing the wholesale module. I uninstalled it, but I am still getting the errors.

[jenbullfrog]

In response to canemasters, that's something to start with in figuring this one out, I also had installed the wholesale module. Didn't have this problem with my previous 1.2.7 version of zen cart with wholesale mod installed though.

I actually am starting with a fresh zen cart, a lot of work, but I couldn't find an answer to this problem, so...

Good luck to everyone having this dilemma!

[canemasters]

I fixed it. I just removed the entries in the database the the wholesale mod put in. Everything is working fine now! woohoo!

[Ajeh]

Thanks for the update and glad this is working for you now ...

[greatness_183]

so does anyone know of a way to get the two to work together? Or can i only have one or the other?

[greatness_183]

Oh .. Just found this .. http://www.zen-cart.com/forum/showth...6+Column+count