Error updating categories

Start
Prev
1
Next
End

Joomill
Topic Author
Away

Posts: 200
Thank you received: 9
Hikashop Multisite

7 years 4 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: 7 years 4 months ago by Joomill.

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

nicolas
Away

Posts: 81478
Thank you received: 13060
MODERATOR

7 years 4 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.