Attribute Error - 1136 Column count

[lemuria]

I have the dual pricing add-on and I was experiencing this error when copying attributes to another product or a category. I made the fixes to admin/includes/functions/general.php that were suggested by Boylan, and that fixed the problem - I can copy attributes to another product.

However, now I can't add options to an item. I get the following error:

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

I attached the products_attributes table to this message:
http://www.zen-cart.com/forum/showpo...6&postcount=76

Is there something additional that I need to add to admin/includes/functions/general.php?

[g0d4lm1ty]

i made the changes and i get the same error still ...

[coke119]

For future reference:

The problem comes because dual prices/wholesale pricing adds a field to the attributes table.

admin/includes/functions/general.php

after line 1914 ish:

          '" . $products_copy_from->fields['options_values_price'] . "',

add:

          '" . $products_copy_from->fields['options_values_price_w'] . "',

after line 1943 ish:

          options_values_price='" . $products_copy_from->fields['options_values_price'] . "',

add:

          options_values_price_w='" . $products_copy_from->fields['options_values_price_w'] . "',

it works, thank you very much

[coke119]

i made the changes and i get the same error still ...

maybe your version is different, I have tried, it works very well

[greatness_183]

It did not seem to work for me .

so I droped "options_values_price_w" in "products_attributes"

They both seem to work fine now .. but I am still testing

[greatness_183]

Ok I take that back .. Not working

[greatness_183]

ok I downloaded "dual pricing_1_3-beta3M"

and reinstalled this and knock on wood it is all working now

made sure i tested for a few days before posting this time .

Hope this helps

[Kudra]

Thanks for posting this fix, it worked perfectly. Veyr much appreciated by us Newer Zenners :)

[canemasters]

Do I add the line

" . $products_copy_from->fields['options_values_price_w'] . "',

after the original code,
or do I just add the "_w" to the current code?

[canemasters]

Nevermind, I played with it and you have to add it right under the existing code. All is working great!