Count doesn't match value

[characterdriven]

Can anyone help me fix my attributes controller? I installed 'Improved Attributes Controller' and...well it wasn't improved. Looked promising as it did exactly what I wanted it to by sorting things nicely, but then when I went to apply the attributes I get this error:

1136 Column count doesn't match value count at row 1
in:
[insert into products_attributes values (0, '5', '1', '2', '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'm pretty desperate to get things working again as I have limited time to stock the store so any help with getting this fixed is much appreciated. I don't really want to lose anything if possible. Hoping for a person much smarter than myself to help as I've tried all the fixed I could find via searching and don't want to muck things up further.

[DrByte]

/admin/attributes_controller.php
line 242 (circa v1.3.7 original edition, not "enhanced"):

 $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . "

change that to this instead:

  $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required)

(Note: you'll need to scroll to the right to get it all .... )

[characterdriven]

/admin/attributes_controller.php
line 242 (circa v1.3.7 original edition, not "enhanced"):

 $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . "

change that to this instead:

  $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required)

(Note: you'll need to scroll to the right to get it all .... )

Thanks! That solved it.

[characterdriven]

Well, it did solve one problem. Now, when I add attibutes and go to duplicate an item, attributes and all, I get this:

1136 Column count doesn't match value count at row 1
in:
[insert into products_attributes values (0, '167', '12', '123', '0.0000', '+', '0', '1', '0', '+', '0', '0', '1', '', '1', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '', '', '0.0000', '0', '0.0000', '0', '0')]

[DrByte]

The same issue exists in 3 files. I only mentioned the one because that was the symptom you were reporting.

/admin/attributes_controller.php
/admin/includes/functions/general.php <-- This is the one affected by Copying attributes
/admin/options_values_manager.php

The fixes for this, and a few others related to different tables, are part of the next release.

[characterdriven]

Is there a hack to fix the 'copying attributes' issue?

The same issue exists in 3 files. I only mentioned the one because that was the symptom you were reporting.

/admin/attributes_controller.php
/admin/includes/functions/general.php <-- This is the one affected by Copying attributes
/admin/options_values_manager.php

The fixes for this, and a few others related to different tables, are part of the next release.

[DrByte]

The same fix applies ... simply add the list of field names in brackets

/admin/includes/functions/general.php
line 1918

          $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '" . $products_id_to . "',

[characterdriven]

Ahhh. I see what you mean. Thanks.

The same fix applies ... simply add the list of field names in brackets

/admin/includes/functions/general.php
line 1918

          $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '" . $products_id_to . "',

[characterdriven]

Oops. Now I'm getting this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0, '172', '12', '123', '0.0000',
in:
[insert into products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '172', values (0, '172', '12', '123', '0.0000', '+', '0', '1', '0', '+', '0', '0', '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.

Ahhh. I see what you mean. Thanks.

[DrByte]

/admin/includes/functions/general.php
line 1929:

          // New attribute - insert it
// @TODO: MySQL5
          $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values (0, '" . $products_id_to . "',

replace with:

          // New attribute - insert it
          $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '" . $products_id_to . "',