Forums / Setting Up Categories, Products, Attributes / Help! Column count doesn't match value count

Help! Column count doesn't match value count

Locked

Started by rjspomer on 27 Jun 2008, 12:16 PM · Views: 1,180

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
27 Jun 2008, 12:16 PM
#1
rjspomer avatar

rjspomer

Zen Follower

Join Date:
Jan 2008
Posts:
173
Plugin Contributions:
0

Help! Column count doesn't match value count

I apologize for duplicating this post but I'm desperate. :frusty:

This is what I get when I try to add an attribute:

1136 Column count doesn't match value count at row 1
in:
[insert into zen_products_attributes values (0, '37', '2', '4', '0', '+', '0', '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.

I have read that I may have an extra field added by some module. What fields should be in the zen_products_attributes?

I have searched and have found reference to this issue after adding Improved attributes controlled modual, but I have not added that modual.

I do have supperorders
lightbox
zahoo and google feeder
Image handler
and others

Thanks for any help with this

27 Jun 2008, 7:09 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Help! Column count doesn't match value count

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.