Can't add product attributes anymore

[Matt_M]

Hi,

 

Now, when I try to add an option to a product, I get a screen that says this:

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values ('', '99', '7', '30', '', '+')

 

[TEP STOP]

 

It didn't do this before, and I don't know what is causing it. Can anyone help?

 

Thanks

[Zeme]

I'm guessing that you must have added a field to your DB. (have you added any contributions lately?).

 

I say this because the base 2.2MS2 install has 6 columns in the products_attributes table. But, if you happen to have added a field to this table, you will have 7+ fields, which is what the error message is trying to say.

 

If you have SQL access, post the results of

 describe products_attributes;

and let me have a look.

 

Hi,

 

Now, when I try to add an option to a product, I get a screen that says this:

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values ('', '99', '7', '30', '', '+')

 

[TEP STOP]

 

It didn't do this before, and I don't know what is causing it. Can anyone help?

 

Thanks

<{POST_SNAPBACK}>