Attribute Error - 1136 Column count

[canemasters]

Okay, so I spoke too soon. I'm still getting


Warning: Missing argument 1 for fckeditor() in fckeditor.php on line 44

This appears right above the editor when I am adding/modifying products using fckeditor and I am unable to make any changes to the product with fckeditor.

I modified my general.php to reflect both:

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

and

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


What am I doing wrong?

[canemasters]

Okay, it actually seems that mixing the fckeditor module and the wholesale module creates 2 problems. The problem where it messes with your attributes was fixed for me when I followed the instructions in this post. However, I'm still unable to use fckeditor to make any changes on my products. I'll read some other posts or start another post.

[bousquetcm]

This actually works:

http://www.zen-cart.com/forum/showth...6+Column+count

[agamic]

For those suffering with this error when adding attributes to an item and who have followed the various fixes, I discovered that in the admin/attributes_controller.php in or around 255 the value options_values_price_w was missing from the list after adding it I didn't get the error again.

Hope this helps as I have been having an uphill struggle with this and I really want to get it working. Now it is transferring the "retail" price to the cart rather than the w/s price, but I think there is a thread somewhere with that problem.


$db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, options_values_price_w, 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)

[Ajeh]

Which add-on are you using that you are getting this error?

[craftzombie]

Which add-on are you using that you are getting this error?

Dual Pricing

[tlyczko]

For those suffering with this error when adding attributes to an item and who have followed the various fixes, I discovered that in the admin/attributes_controller.php in or around 255 the value options_values_price_w was missing from the list after adding it I didn't get the error again.

Hope this helps as I have been having an uphill struggle with this and I really want to get it working. Now it is transferring the "retail" price to the cart rather than the w/s price, but I think there is a thread somewhere with that problem.


$db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, options_values_price_w, 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)

I am also using the dual pricing mod and this was the only change I had to make to get attributes added...still have to check on the retail/wholesale display etc., but my situation is easier while people must choose attributes, the attributes don't change the prices.

Thank you, Tom

[cutterscreek]

For those suffering with this error when adding attributes to an item and who have followed the various fixes, I discovered that in the admin/attributes_controller.php in or around 255 the value options_values_price_w was missing from the list after adding it I didn't get the error again.

Hope this helps as I have been having an uphill struggle with this and I really want to get it working. Now it is transferring the "retail" price to the cart rather than the w/s price, but I think there is a thread somewhere with that problem.


$db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, options_values_price_w, 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)

This fix worked perfectly for me. Thank you thank you!!

[Decostyle]

I'm using zen 1.3.8 and tried both fixes and still doesn't work

I have dual pricing running right now. Any other suggestions?

[Decostyle]

This is the error I get:

1136 Column count doesn't match value count at row 1
in:
[insert into zen_products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, options_values_price_w, 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, '4', '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.