I really like the idea of this mod as I sell books and use bar codes, but I have a store full of items and when I go to edit anything this is what I get:
1054 Unknown column 'p.products_upc' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_upc, p.products_isbn, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_weight_type, p.products_dim_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from products p, products_description pd where p.products_id = '1418' and p.products_id = pd.products_id and pd.language_id = '1']
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 tried uninstalling using the provided sql and reverted to backup files, but the message doesn't go away and I still can't edit items in my store which I need to be able to do as soon as possible. I have exhausted all my own ideas and am wondering if anyone can help me decipher what is wrong here and how to a) get rid of the original installation and start fresh so I can resume editing the store items b) tell me if it's possible to 'retrofit' this mod so that it can be used on existing items, or to at least let me access them for editing even if they don't contain the extra fields?
Bookmarks