Hi there everyone,
Latest mods on latest cart. I ran the upgrade files for the dynamic dropdown via the SQL patch page upload feature, which I think may have neglected to add the proper db prefix somewhere. When I visit a product page, I receive the following error where the dropdown belongs:
Which makes sense because my table is named "137_products_with_attributes_stock" and not "products_with_attributes_stock"1146 Table 'store.products_with_attributes_stock' doesn't exist
in:
[SELECT quantity FROM products_with_attributes_stock AS a LEFT JOIN products_attributes AS b ON (b.options_id=3 AND b.options_values_id=29) WHERE a.products_id = '796' AND a.stock_attributes = b.products_attributes_id AND a.quantity > 0 order by b.products_options_sort_order]
I'm afraid to rerun the patches another way without talking to someone first and I can't find any reference to this table in the sql patches that come with the mod.
Any help would be greatly appreciated as I've got a client's site disabled until resolved.
thanks,
json



