- Posts: 4
- Thank you received: 0
table does not exist - column does not exist
10 years 7 months ago #231014
by abpweb
table does not exist - column does not exist was created by abpweb
-- 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
-- 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
Please Log in or Create an account to join the conversation.
10 years 7 months ago #231019
by nicolas
Replied by nicolas on topic table does not exist - column does not exist
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.
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.184 seconds