Zen Cart Logo

Attributes error

Locked

Views: 2,294

Results 1 to 15 of 15
This thread is locked. New replies are disabled.
7 Apr 2007, 6:56 AM
#1
vivaraquel avatar

vivaraquel

Zen Follower

Join Date:
Sep 2004
Location:
Australia
Posts:
305
Plugin Contributions:
0

Attributes error

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.

16 May 2007, 3:53 PM
#3
jenbullfrog avatar

jenbullfrog

Zen Follower

Join Date:
Oct 2005
Location:
Helena, MT
Posts:
110
Plugin Contributions:
0

Re: Attributes error

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

17 May 2007, 3:22 AM
#4
p137 avatar

p137

New Zenner

Join Date:
May 2007
Posts:
20
Plugin Contributions:
0

Re: Attributes error

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

18 May 2007, 5:09 PM
#5
canemasters avatar

canemasters

Zen Follower

Join Date:
Mar 2007
Posts:
444
Plugin Contributions:
0

Re: Attributes error

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.

18 May 2007, 5:24 PM
#6
jenbullfrog avatar

jenbullfrog

Zen Follower

Join Date:
Oct 2005
Location:
Helena, MT
Posts:
110
Plugin Contributions:
0

Re: Attributes error

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!

18 May 2007, 5:30 PM
#7
canemasters avatar

canemasters

Zen Follower

Join Date:
Mar 2007
Posts:
444
Plugin Contributions:
0

Re: Attributes error

This sucks in a way that I cant even explain! I am unable to add any new products because of this wholesale module! I uninstalled it and it is still happening. Somebody has to know what the solution is. :censored::censored::censored::censored:!!!

18 May 2007, 5:33 PM
#8
jenbullfrog avatar

jenbullfrog

Zen Follower

Join Date:
Oct 2005
Location:
Helena, MT
Posts:
110
Plugin Contributions:
0

Re: Attributes error

Hmmmm, I wonder if your problem is not the wholesale module. I was able to add new products after installing the wholesale mod.

18 May 2007, 6:23 PM
#9
canemasters avatar

canemasters

Zen Follower

Join Date:
Mar 2007
Posts:
444
Plugin Contributions:
0

Re: Attributes error

I'm going to create a new sql database and swap to it and see if I have the same problem. I'll post my results. I may just end up having to recreate everything on my site.

18 May 2007, 6:55 PM
#10
canemasters avatar

canemasters

Zen Follower

Join Date:
Mar 2007
Posts:
444
Plugin Contributions:
0

Re: Attributes error

Nevermind, I'm not reinstalling zencart just to get a new database. I've gota get this problem fixed. Cant anybody help me on this?

19 May 2007, 4:12 AM
#11
canemasters avatar

canemasters

Zen Follower

Join Date:
Mar 2007
Posts:
444
Plugin Contributions:
0

Re: Attributes error

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

24 May 2007, 3:59 PM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Attributes error

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

26 May 2007, 1:05 PM
#13
greatness_183 avatar

greatness_183

New Zenner

Join Date:
May 2007
Location:
Wales
Posts:
28
Plugin Contributions:
0

Re: Attributes error

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