New Zenner
- Join Date:
- May 2006
- Posts:
- 22
- Plugin Contributions:
- 0
Attribute Error
I have set up a list of dates as attributes for courses I run so rather than participants having lots of 'products' to choose from, they can just tick the date they want and bobs-your-uncle. However being dates I'd like them to list chronologically but when I try to set the order for them I get this error.
1054 Unknown column 'attributes_default' in 'field list'
in:
[update products_attributes set products_id = '106', options_id = '6', options_values_id = '12', options_values_price = '0.0000', price_prefix = '+', products_options_sort_order = '5', product_attribute_is_free = '1', products_attributes_weight = '0', products_attributes_weight_prefix = '+', attributes_display_only = '0', attributes_default = '0', attributes_discounted = '1', attributes_price_base_included = '1', attributes_price_onetime = '0.0000', attributes_price_factor = '0.0000', attributes_price_factor_offset = '0.0000', attributes_price_factor_onetime = '0.0000', attributes_price_factor_onetime_offset = '0.0000', attributes_qty_prices = '', attributes_qty_prices_onetime = '', attributes_price_words = '0.0000', attributes_price_words_free = '0', attributes_price_letters = '0.0000', attributes_price_letters_free = '0', attributes_required = '0' where products_attributes_id = '182']
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.
I may have messed something up when I transferred my data across from OSc to Zen ... have I got an extra column in my attributes database and if so which one.
Look under Silva Map and Compass Courses, Bronze for the problem. http://shop.petehawkins.co.uk
All help as ever greatly appreciated.
Pete
