Filter categories - Error

  • Posts: 429
  • Thank you received: 19
7 years 10 months ago #260403

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

Attachments:
Last edit: 7 years 9 months ago by neo191987.

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
7 years 9 months ago #260449

Hi,

Thank you for your feedback. We've added a patch for that.
Download the install package on our website again and install it again on yours and it will add a patch for that.

The following user(s) said Thank You: neo191987

Please Log in or Create an account to join the conversation.

Time to create page: 0.060 seconds
Powered by Kunena Forum