Results 1 to 10 of 34

Hybrid View

  1. #1

    Default Re: Attribute Error - 1136 Column count

    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?

  2. #2

    Default Re: Attribute Error - 1136 Column count

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

  3. #3

    Default Re: 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?

  4. #4

    Default Re: Attribute Error - 1136 Column count

    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.

  5. #5
    Join Date
    Sep 2007
    Posts
    6
    Plugin Contributions
    0

    Default Re: Attribute Error - 1136 Column count


  6. #6
    Join Date
    Apr 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: Attribute Error - 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)

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Attribute Error - 1136 Column count

    Which add-on are you using that you are getting this error?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  8. #8
    Join Date
    Dec 2003
    Location
    UPstate NY
    Posts
    440
    Plugin Contributions
    0

    Idea or Suggestion Re: Attribute Error - 1136 Column count

    Quote Originally Posted by agamic View Post
    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

  9. #9
    Join Date
    Mar 2008
    Posts
    25
    Plugin Contributions
    0

    Default Re: Attribute Error - 1136 Column count

    Quote Originally Posted by agamic View Post
    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!!

 

 

Similar Threads

  1. v139h 1136 Column count doesn't match value count at row 1
    By riolas in forum General Questions
    Replies: 3
    Last Post: 5 Jul 2013, 07:48 AM
  2. Replies: 6
    Last Post: 25 Mar 2009, 08:41 PM
  3. 1136 Column count doesn't match value count
    By evariety in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 22 Jan 2009, 10:36 AM
  4. After QBI Install - 1136 Column count doesn't match value count at row 1
    By Bostitch in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 2 Apr 2008, 09:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg