Originally Posted by
deko
Right, well that seemed to work for orders_product table :)
First ran the column update...
ALTER TABLE orders_products ADD products_prid TINYTEXT NOT NULL;
Then copied values from products_id...
UPDATE orders_products SET products_prid = products_id;
Now I can see the list of order totals, which I couldn't see last night.
Now to populate the other two tables, 'orders_products_attributes' and orders_products_download'. My dev versions are empty, so if anyone has values in these tables, can you paste a few lines so we can see if they follow the same route.
Of course, all this might be completely wrong yet :)
Bookmarks