Attribute Error

[PeteH]

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

[Ajeh]

Looks like you do not have all of the new fields in the table so you are getting errors ...

Compare your database table structure to a clean v1.3.5 in a test database loaded to a test directory such as /test_shop with the demo data loaded to help you learn as you go along ...

[PeteH]

Ajeh,

Saved the day again. I had added an underscore after attributes_default .. simple correction and All's well.

Thank you.


Pete

[Ajeh]

Thanks for the update and glad you found your error ...