Smart Search Exact Phrase Error

-- url of the page with the problem -- : unicommsemall.com
-- HikaShop version -- : Business 2.64
-- HikaMarket version -- : 1.7.2
-- Joomla version -- : 3.6.3
-- PHP version -- : 5.6.24
-- Browser(s) name and version -- : 4
-- Error-message(debug-mod must be tuned on) -- : Error 1064- Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%chair%' AND vendor. LIKE '%chair%' ORDER BY vendor.vendor_created DESC, v' at line 1 SQL=SELECT DISTINCT vendor.vendor_id AS id, vendor.vendor_name AS title, vendor.vendor_description AS text, vendor_created as created, "1" AS browsernav FROM #__hikamarket_vendor AS vendor WHERE vendor.vendor_published = 1 AND vendor. LIKE '%chair%' AND vendor. LIKE '%chair%' ORDER BY vendor.vendor_created DESC, vendor.vendor_id DESC LIMIT 0, 50

Hi guys,

We have the Hikashop Business and Hika Market installed.

The Smart Search is giving out error code 1064 when you run an "Exact Phrase" search, but is ok in other search modes. The system is running on MySQLi and MySQL is version 5.6.24 as reported by Joomla.

The error is - Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%chair%' AND vendor. LIKE '%chair%' ORDER BY vendor.vendor_created DESC, v' at line 1 SQL=SELECT DISTINCT vendor.vendor_id AS id, vendor.vendor_name AS title, vendor.vendor_description AS text, vendor_created as created, "1" AS browsernav FROM #__hikamarket_vendor AS vendor WHERE vendor.vendor_published = 1 AND vendor. LIKE '%chair%' AND vendor. LIKE '%chair%' ORDER BY vendor.vendor_created DESC, vendor.vendor_id DESC LIMIT 0, 50

You can running an Exact Phrase search from our page unicommsemall.com

Thanks.

We have turned off the Advanced Search Options for now until the problem is resolved. Thanks.