attributes not working

Hello there.

I have some attributes setup on my proudcts.

I loaded the newest version of zc along with some of the working contribs.

for some reason i can no longer add attributes to my proudcts. I get this error

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

anyone know how to fix this problem?

i just tried to install Improved attributes controlled modual. it makes things easyer, however it still dont work, i get the same error.

i also tried to reset the attributes sort order in TOOLS>Store Manager, but that didnt help any eather...

any advice on this problem would be very helpfull, as i have no idea how to fix it.

sorry for all the posts, but iv been looking for a fix for this..

i read all the posts i could find on "1136 Column" per instructions i found on another topic re. the same issue.

however i didnt find any fix for the problem, other than finding what moduals where installed.

Currently i have the fallowing.

Super Orders2
Info at a glance
export email address
encrypted master pass
quick updates
recover carts
order questions
Tabbed products lite - admin edition
zen lightbox

all these where installed when i noticed the problem.
i just installed Improved Atributes controller, hoping it would fix the issue. however it didnt seem to help at all...

issue fixed.

Seems i had a field inside the Products_attributes table that was for an old modual that i installed...

Must have been carried over to the new install when i upgraded, however its odd that it just broke now. was working fine for the last 3 weeks since i did the upgrade to the new version...

wonder what happend.....

anyways, its fixed, you can remove the topic if you would like..

Thanks for the update that what was causing the problems was an old add-on ... :smile:

what exactly did you do to fix this? i have the same issue

anjordan77:

what exactly did you do to fix this? i have the same issue

there was a field inside the database under product_attributes. it was somthing the ended in _w.

In products_attributes table:
options_values_price_w

and you may also need to remove

In products table:
products_price_w

this is a risky fix, so make sure that you backup before you attempt it. it seemed to solve my problems right away, so we will see if its the same for you.
good luck!

Thank you so much for posting this, this was exactly the same problem I was experiencing.