Mass Action Problem

  • Posts: 377
  • Thank you received: 7
9 years 1 week 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: 2322
9 years 1 week 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: 268
  • Thank you received: 7
  • Hikamarket Frontedition Hikamarket Multivendor Hikaserial Standard Hikashop Business
4 years 1 week 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: 82867
  • Thank you received: 13374
  • MODERATOR
4 years 1 week 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: 268
  • Thank you received: 7
  • Hikamarket Frontedition Hikamarket Multivendor Hikaserial Standard Hikashop Business
4 years 1 week 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: 82867
  • Thank you received: 13374
  • MODERATOR
4 years 1 week 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: 268
  • Thank you received: 7
  • Hikamarket Frontedition Hikamarket Multivendor Hikaserial Standard Hikashop Business
4 years 1 week ago #326024

Thank you! that was it

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

Time to create page: 0.086 seconds
Powered by Kunena Forum