Error updating categories

  • Posts: 111
  • Thank you received: 3
  • Hikashop Business
2 years 10 months ago #257628

-- HikaShop version -- : 2.6.4

I need a mass-action to set the category automaticly to our products

When i update the categories i get an error.

Settings:



Result:


If i change the settings for the next category 10-20 euro.


The error changes to:


I download the latest version today and rebuild categories, but don't work.
Can you point me in the right direction?

Attachments:
Last edit: 2 years 10 months ago by Joomill.

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

  • Posts: 67109
  • Thank you received: 9946
  • MODERATOR
2 years 10 months ago #257630

Hi,

1. That's because some of the products with a price <= 10 are already linked to that category.
So please add a filter so that the products aren't already in that category and you shouldn't get that error.

2. For that error, it's because the system doesn't support having two filters on the price.
Try changing the line:

$query->leftjoin[] = hikashop_table('price').' AS hk_price ON hk_price.price_product_id = hk_product.product_id';
to:
$query->leftjoin['hk_price'] = hikashop_table('price').' AS hk_price ON hk_price.price_product_id = hk_product.product_id';
in the file plugins/hikashop/massaction_product/massaction_product.php and that should fix the problem.
Let us know how it goes so that we can include the fix for the next release.

The following user(s) said Thank You: Joomill

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

  • Posts: 111
  • Thank you received: 3
  • Hikashop Business
2 years 10 months ago #257657

Nicolas,

1) Added a filter for the first error. Works fine.
2) Code tested successfully!

Thank you!

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

  • Posts: 67109
  • Thank you received: 9946
  • MODERATOR
2 years 9 months ago #257668

Thanks for your feedback !

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

Time to create page: 0.063 seconds
Powered by Kunena Forum