error message mass action for productfilter

Start
Prev
1
Next
End

michelpouli
Topic Author
Offline

Posts: 506
Thank you received: 21
Hikashop Business

4 years 3 months ago #314737

-- HikaShop version -- : 4.2.2
-- Joomla version -- : 3.9.14
-- PHP version -- : 7.3
-- Error-message(debug-mod must be tuned on) -- : You have an error in your SQL syntax

Hi,

I'm trying to create a mass action to add a priceupdate for several products. After assigning a category I want to filter on a part of the product_name, but when choosing the product_column in the dropdownmenu of the filters I get this errormessage:

Attachments:

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

nicolas
Away

Posts: 81513
Thank you received: 13067
MODERATOR

4 years 3 months ago #314743

Hi,

Could you please do that screenshot again after:
- activating the "error reporting" and "debug mode" settings of the Joomla configuration in order to get more information on the error location
- applying this change in the code of Joomla in order to get the full MySQL query generating that error:
www.hikashop.com/support/forum/product-c...eld-list.html#304882
That will help us understanding the situation and providing a solution.

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

michelpouli
Topic Author
Offline

Posts: 506
Thank you received: 21
Hikashop Business

4 years 3 months ago #314756

Here's the new screenshot:

Attachments:

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

nicolas
Away

Posts: 81513
Thank you received: 13067
MODERATOR

4 years 3 months ago #314758

Hi,

Thank you, I see what is the problem.
Add the code:

$filter['type'] = '`'.$filter['type'].'`';

after the line:

$filter['type'] = strip_tags($filter['type']);

in the file administrator/components/com_hikashop/classes/massaction.php and that should fix the problem.
We'll add that patch on our end too for the next version.

The following user(s) said Thank You: michelpouli

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