table does not exist - column does not exist

  • Posts: 4
  • Thank you received: 0
8 years 1 month ago #231014

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.4.45
-- Browser(s) name and version -- : Chrome

Hi.
I have a custom field on product table, called pcscase.
I need to have a mass action that updates the value of the price.
The value of the price should be price_value = (operation) price.price_value * product.pcscase
When i execute this mass action, it says that these tables and columns does not exist,
but when i modify mass action to price_value = (operation) price.price_value * 2 it works
Also when i modify mass action to price_value = (operation) product.pcscase * 2 it works too.
How is it possible that when i multiply this 2 columns, it does not work:
price_value = (operation) price.price_value * product.pcscase

Attachments:

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

  • Posts: 81484
  • Thank you received: 13062
  • MODERATOR
8 years 1 month ago #231019

Hi,

That indeed is not possible with the version of HikaShop you're using. Operations between different columns is something we've added later on. You need to update HikaShop and then it will work.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum