Error updating categories

  • Posts: 104
  • Thank you received: 3
  • Hikashop Business
2 years 5 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 5 months ago by Joomill.

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

  • Posts: 65624
  • Thank you received: 9578
  • MODERATOR
2 years 5 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: 104
  • Thank you received: 3
  • Hikashop Business
2 years 5 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: 65624
  • Thank you received: 9578
  • MODERATOR
2 years 5 months ago #257668

Thanks for your feedback !

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

Time to create page: 0.082 seconds
Powered by Kunena Forum