-- 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