-- HikaShop version -- : 3.0.0
-- Joomla version -- : 3.6.5
-- PHP version -- : 7.1.1
This error occurs only in php 7.1.1
Hi after publication of the filter for categories displayed the following error:
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 ') AND a.category_parent_id=17 AND (a.category_access = 'all' OR a.category_acces' at line 1 SQL=SELECT * FROM #__hikashop_category AS a LEFT JOIN #__hikashop_product_category AS b ON a.category_id=b.category_id WHERE a.category_published=1 AND b.product_id IN () AND a.category_parent_id=17 AND (a.category_access = 'all' OR a.category_access LIKE '%,8,%') ORDER BY a.category_ordering ASC
Settings: