Search not working for Hikaship

-- url of the page with the problem -- : community.advancn.org/books
-- HikaShop version -- : 4.4.0
-- Joomla version -- : 3.9.23
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) GROUP BY (a.product_id) ORDER BY a.product_name DESC LIMIT 0, 50' at line 1

I am attempting to use the joomla search module for product and have received the following error:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) GROUP BY (a.product_id) ORDER BY a.product_name DESC LIMIT 0, 50' at line 1

Hi,

Please:
- do the modification here: www.hikashop.com/support/forum/install-u...ror-1064.html#326783
- turn on the "error reporting" and "debug mode" settings of the Joomla configuration
- try again and provide a screenshot of all the information about the error on the page. You should get the full MySQL query creating the error and a call stack which will help us understand what is going on.

I have set debug mode.
Images and video: vimeo.com/491199525

Hi,

It seems that you didn't do the modification in the file as I proposed in my previous message.
Could you do the modification in www.hikashop.com/support/forum/install-u...ror-1064.html#326783 ?
That way, the error message will contain the full MySQL query, which will help understand what's going on.

Thank you, its working fine now.