Mass Action Problem

  • Posts: 377
  • Thank you received: 7
5 years 5 months ago #220811

-- url of the page with the problem -- : www.tradeheatingspares.com
-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.2.7
-- Error-message(debug-mod must be tuned on) -- : Backend error only

When i try to implement a mass action i get the following message:

Message

Successfully Saved

The table 1 does not exist

However i have not seen anything change. It used to work however i think updating to the latest version has potentially stopped it from working. Please see the config attached.

Attachments:

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

  • Posts: 13201
  • Thank you received: 2319
  • MODERATOR
5 years 5 months ago #220823

Hi,

Please use: hk_price.price_value*1.05
Instead of: price.price_value*1.05

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

  • Posts: 197
  • Thank you received: 6
  • Hikamarket Frontedition Hikamarket Multivendor Hikaserial Standard Hikashop Business
5 months 3 weeks ago #325955

I'm having the same problem. tried adding the hk to the formula but no luck.

Trigger - none
Filter = category_id=12
Limitations= 0-500
Actions = "Update the values", "price_value", "Operation", "round(price_value*.9,0)"

Message I get:
Message
Successfully Saved
The table does not exist

Any help gratefully recieved

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

  • Posts: 72763
  • Thank you received: 11096
  • MODERATOR
5 months 3 weeks ago #325986

Hi,

It should be round(price.price_value*.9,0) instead of round(price_value*.9,0)

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

  • Posts: 197
  • Thank you received: 6
  • Hikamarket Frontedition Hikamarket Multivendor Hikaserial Standard Hikashop Business
5 months 3 weeks ago #325988

my apologies, I had tried that too with the same result. had also tried hk_price.price_value, hikashop_price.price_value and several others all with same or similar results

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

  • Posts: 72763
  • Thank you received: 11096
  • MODERATOR
5 months 3 weeks ago #325996

Hi,

My apologies,it should be round(price.price_value*0.9,0) instead of round(price.price_value*.9,0)

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

  • Posts: 197
  • Thank you received: 6
  • Hikamarket Frontedition Hikamarket Multivendor Hikaserial Standard Hikashop Business
5 months 3 weeks ago #326024

Thank you! that was it

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

Time to create page: 0.075 seconds
Powered by Kunena Forum