-- url of the page with the problem -- :
mywebsite.com/mypage
-- HikaShop version -- : 2.2.2
-- Joomla version -- : 3.2
-- PHP version -- : 5.3.8
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'hk_product.price_value' in 'field list' SQL=UPDATE udfu2_hikashop_product AS hk_product LEFT JOIN udfu2_hikashop_price AS hk_price ON hk_price.price_product_id = hk_product.product_id SET hk_product.price_value = 33.33 WHERE hk_product.product_id IN (2,5,4,14,16,17,18,19,20,22,23,24,25,27,28,30,31,33,35,36,37,38,39,40,41,43,44,47,48,50,56,58,59,60,61,64,67,68,71,72,75,77,78,79,80,81,82,85,87,89,90,91,92,95,96,98,112)
I am trying to change all prices where current price = £50 to a new value of £33.33 but get the error above.
The Mass Actions settings are:
Trigger - none set as it is a one-off action triggered manually.
Filters: Price columns price_value = 50.00
Actions: price_value = FLOAT 33.33
Am I doing something wrong?
Thanks
Trevor