error message mass action for productfilter

  • Posts: 503
  • Thank you received: 21
  • Hikashop Business
4 years 1 month 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.

  • Posts: 81182
  • Thank you received: 12995
  • MODERATOR
4 years 1 month 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.

  • Posts: 503
  • Thank you received: 21
  • Hikashop Business
4 years 1 month ago #314756

Here's the new screenshot:

Attachments:

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

  • Posts: 81182
  • Thank you received: 12995
  • MODERATOR
4 years 1 month 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.

  • Posts: 503
  • Thank you received: 21
  • Hikashop Business
4 years 1 month ago #314778

Thanks Nicolas!

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

Time to create page: 0.080 seconds
Powered by Kunena Forum