Thread: Attribute error

Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    215
    Plugin Contributions
    0

    Default Attribute error

    I'm trying to set up some attributes and I keep getting an error message which is as follows:

    1136 Column count doesn't match value count at row 1
    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, '195', '1', '29', '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.

    Seems to be a database problemo. Any ideas how to correct this?

    I'm using 1.3.8.
    Last edited by enquirer66; 14 Apr 2008 at 07:00 AM. Reason: added something

  2. #2
    Join Date
    Sep 2007
    Posts
    215
    Plugin Contributions
    0

    Default Re: Attribute error

    I have resolved this issue by deleting the module Dual Pricing - obviously some kind of incompatibility with this and other features - see other post concerning problems showing Customer details with this module installed. How can one reverse the sql command when one first installed this module?

 

 

Similar Threads

  1. v155 Attribute controller - error message when adding attribute values
    By rustwood in forum General Questions
    Replies: 8
    Last Post: 11 Jul 2016, 10:26 PM
  2. Attribute Error
    By Rizla in forum General Questions
    Replies: 1
    Last Post: 9 Aug 2014, 09:39 PM
  3. Attribute Error
    By jakumpe in forum Setting Up Categories, Products, Attributes
    Replies: 16
    Last Post: 26 Nov 2007, 05:46 AM
  4. Attribute error
    By julie.t in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 10 Feb 2007, 05:39 PM
  5. Attribute Error
    By PeteH in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 28 Oct 2006, 05:52 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