Attribute Error - 1136 Column count

[laurelee]

I am attempting to "Copy to Category" in the Attributes Controller for one product's attributes to an entire category. However, everytime I go to Copy, I am getting the following message:

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

I have tried copying to just one product with all options (Delete, Upgrade, or Ignore) and the same error occurs. I was able to succeed in this action about 1 1/2 weeks ago doing the same thing, however, all of a sudden today, it is not working. Any info into why this is happening or what I can do to fix it would be greatly appreciated!

FYI - I am using the latest version of Zen Cart.

[Ajeh]

Did you add any add-ons to your shop that would of altered the table structure?

[laurelee]

I only added the wholesale price add-on that allows me to have many different prices only seen by specific people. I don't believe this should affect the attributes, but I guess I could be wrong :)

[Ajeh]

Compare your current structure of your database with the structure of a clean Zen Cart database and see if you suddenly have new fields and such that could be causing this related to attributes ...

[hrm]

I have the same problem and yes there are extra fields

In products table:
products_price_w

In products_attributes table:
options_values_price_w

Is there a fix?

Heather

[Ajeh]

Any idea what add-on you might have installed on your site?

Sounds like perhaps it has altered the code as well as the database ...

[hrm]

Dual Pricing

Yes, it did alter the code -- and, incidentally, I'm using 1.2.6d.

Any ideas?

Heather

[Ajeh]

Perhaps check the threads on that add-on and see what has broken on your site ...

[boylan]

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'] . "',

[Ajeh]

Thanks for posting an update to this issue when using those add-ons ...