19 Jan 2009, 12:24 PM
New Zenner
- Join Date:
- Sep 2006
- Location:
- Loch Victoria Australia
- Posts:
- 45
- Plugin Contributions:
- 0
problems with product changes
I've just upgraded to 1.3.8 from 1.3, I'm still working through the bits and pieces to make sure Its all running again. My first hiccough has been the following message if I try to change an existing catalogue product entry. e.g. I want to change the number available from 1 to nil. (which I do whenever I sell something direct in my physical shop)
I get the following message. on a plain white screen
(I've searched the forum and can't find it listed anywhere so I'm sorry if I'm repeating a problem already dealt with.)
1054 Unknown column 'products_height' in 'field list'The only thing I changed was the quantity from 1 to 0 then I just left it blank a second time to see if that made any difference. any ideas?
in:
[update zen_products set products_quantity = '0', products_type = '5', products_model = '', products_price = '0', products_date_available = null, products_weight = '0.42', products_height = '0', products_length = '0', products_width = '0', products_status = '0', products_virtual = '0', products_tax_class_id = '0', manufacturers_id = '0', products_quantity_order_min = '1', products_quantity_order_units = '1', products_priced_by_attribute = '0', product_is_free = '0', product_is_call = '0', products_quantity_mixed = '1', product_is_always_free_shipping = '0', products_qty_box_status = '1', products_quantity_order_max = '0', products_sort_order = '0', products_discount_type = '0', products_discount_type_from = '0', products_price_sorter = '65.0000', products_image = 'viking wire.jpg', products_last_modified = now(), master_categories_id = '2' where products_id = '118']
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.
