Hi Rod,
An odd one for you. I created a new site for our favourite horsey shop, for some new products. It was a clean install of 1.3.9h, without any of the old data for products or customers. In other words, a fresh start. Nevertheless, the product input fields contain the "products_height, products_length, products_width" fields, which I think come only from OzPost. The OzPost files were uploaded as usual (v2.0.5) because I thought J wanted it, but when its Install button was clicked I got a warning about cURL not working. I left it at that as the site was in limbo at the time. Now J is entering, or trying to enter, new products and is getting the following warning...
I tried carefully removing all the files, either completely or in some cases replacing them with the stock ZC files, to no avail.1054 Unknown column 'products_height' in 'field list'
in:
[insert into products (products_quantity, products_type, products_model,
products_price, products_date_available, products_weight, products_height,
products_length, products_width, products_status, products_virtual,
products_tax_class_id, manufacturers_id, products_quantity_order_min,
products_quantity_order_units, products_priced_by_attribute,
product_is_free, product_is_call, products_quantity_mixed,
product_is_always_free_shipping, products_qty_box_status,
products_quantity_order_max, products_sort_order, products_discount_type,
products_discount_type_from, products_price_sorter, products_image,
products_date_added, master_categories_id) values ('10', '1', '125685',
'80', null, '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '0', '0', '0',
'1', '0', '1', '0', '0', '0', '0', '0', '', now(), '4')]
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'm guessing the DB was modified during the incomplete OzPost install. But I can't hit the Remove button because it's not fully installed. J has decided not to use OzPost this time, preferring free shipping. So how do I get rid of the three dimension fields and the incorrect SQL command during creation of new products?
Rob
Bookmarks