[Skip to main content](#vessel-content) # table does not exist - column does not exist ## - **[abpweb](/forum/user/35844-abpweb "View abpweb's Profile")** - [![abpweb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35844-abpweb "View abpweb's Profile") Topic Author - [ Offline](/forum/user/35844-abpweb) Less More - Posts: 4 - Thank you received: 0 - - 10 years 8 months ago [\#231014](#231014) by [abpweb](/forum/user/35844-abpweb "View abpweb's Profile") *[table does not exist - column does not exist](/forum/44-mass-actions/882551-table-does-not-exist-column-does-not-exist#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")* was created by *[abpweb](/forum/user/35844-abpweb "View abpweb's Profile")* -- 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 - [ ![hikashop-mass-action.jpg](/forum/attachment/29707) ](/forum/attachment/29707 "...ass-action.jpg") [ ](/forum/attachment/29707?download=1 "...ass-action.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODI1NTEtdGFibGUtZG9lcy1ub3QtZXhpc3QtY29sdW1uLWRvZXMtbm90LWV4aXN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 10 years 8 months ago [\#231019](#231019) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[table does not exist - column does not exist](/forum/44-mass-actions/882551-table-does-not-exist-column-does-not-exist#231019 "-- 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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODI1NTEtdGFibGUtZG9lcy1ub3QtZXhpc3QtY29sdW1uLWRvZXMtbm90LWV4aXN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.147 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)