Zen Cart Logo

Attribute error

Locked

Views: 895

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
14 Apr 2008, 5:58 AM
#1
enquirer66 avatar

enquirer66

Zen Follower

Join Date:
Sep 2007
Posts:
215
Plugin Contributions:
0

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.

14 Apr 2008, 6:31 AM
#2
enquirer66 avatar

enquirer66

Zen Follower

Join Date:
Sep 2007
Posts:
215
Plugin Contributions:
0

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?