Error updating categories

Start
Prev
1
Next
End

Joomill
Topic Author
Offline

Posts: 206
Thank you received: 10
Hikashop Multisite

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

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

nicolas
Away

Posts: 82863
Thank you received: 13372
MODERATOR

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