-- 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:
HIKASHOP ESSENTIAL 49,95€The basic version. With the main features for a little shop.
HIKAMARKETAdd-on Create a multivendor platform. Enable many vendors on your website.
HIKASERIALAdd-on Sale e-tickets, vouchers, gift certificates, serial numbers and more!
MARKETPLACEPlugins, modules and other kinds of integrations for HikaShop
HIKAAUCTION 40€Add-on Create auctions and let your customers bid for products.
ACCESS THE CHECKOUTClick here to access the payment area
