[SOLVED] Error when trying to Mass edit prices

  • Posts: 306
  • Thank you received: 42
  • Hikamarket Multivendor Hikaserial Standard Hikashop Business
12 years 5 months ago #131760

-- 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

Last edit: 12 years 5 months ago by trevsmiff.

Please Log in or Create an account to join the conversation.

  • Posts: 85445
  • Thank you received: 13972
  • MODERATOR
12 years 5 months ago #131800

Hi,

Please replace the file plugins/hikashop/massaction_product/massaction_product.php with the one in the archive enclosed and try again.


This attachment is hidden for guests.
Please log in or register to see it.

This message has an attachment file.
Please log in or register to see it.

The following user(s) said Thank You: trevsmiff

Please Log in or Create an account to join the conversation.

  • Posts: 306
  • Thank you received: 42
  • Hikamarket Multivendor Hikaserial Standard Hikashop Business
12 years 5 months ago #131805

Thanks again Nicolas - works a treat.

Trevor

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum