Attribute Error - 1136 Column count

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?

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.

This actually works:

http://www.zen-cart.com/forum/showthread.php?t=55439&highlight=1136+Column+count

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)

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

Ajeh:

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

Dual Pricing

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)

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

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)

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

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?

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.

Ok I got it fixed! The problem was I was using a fresh file of attributes_controller.php from the zencart file and not the one provided by dual pricing.

You should use the attributes_controller.php from dual pricing, insert the options_values_price_w on there and then upload it to the server!

I have the dual pricing module... i didn't realize it came with the attributes_controller.php as well.. do you have a link?

ignore my comment, yes I have everything. My problem seems to be sql issue.

I would like to use Dual Pricing but concerned about the attributes problems. I installed an updated attributes controller to be able to make bulk attribute changes. Will this cause a problem since it is already installed?