Attribute Error - 1136 Column count

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.

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

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 :)

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 ...

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

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 ...

Dual Pricing

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

Any ideas?

Heather

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

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

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

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/showpost.php?p=296776&postcount=76

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

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

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

it works, thank you very much

g0d4lm1ty:

i made the changes and i get the same error still ... :(
maybe your version is different, I have tried, it works very well

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
:clap:

Ok I take that back .. Not working

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

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

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?

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