1064 You have an error in your SQL syntax

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.4.3
-- Error-message(debug-mod must be tuned on) -- : I receive the error message when i do mass action on root category:

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 ') OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk_product.* FROM Chau_hikashop_product as hk_product WHERE (product_id IN () OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500

I make the following change and same problem

$query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.(int)$this->database->Quote($element).' LIMIT 1';
$this->database->setQuery($query);
$element = (int)$this->database->loadResult();

I receive the error message when i do mass action on root category:

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 ') OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk_product.* FROM Chau_hikashop_product as hk_product WHERE (product_id IN () OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500

I make the following change and same problem

$query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.(int)$this->database->Quote($element).' LIMIT 1';
$this->database->setQuery($query);
$element = (int)$this->database->loadResult();

I've got this message when trying to access Dashboard for HikaShop:
An error has occurred.
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 '*, COUNT(a.order_id) AS total FROM #__hikashop_order AS a LEFT JOIN #__hik' at line 1

What to do?

Hi,

New MySQL query leading to that error:
( www.hikashop.com/support/forum/2-general...ror-1054.html#287524 )

An error has occurred.
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 '*, COUNT(a.order_id) AS total FROM #__hikashop_order AS a LEFT JOIN #__hik' at line 1 SELECT DISTINCT(prod.order_product_id), *, COUNT(a.order_id) AS total FROM hklco_hikashop_order AS a LEFT JOIN hklco_hikashop_order_product AS prod ON prod.order_id = a.order_id LEFT JOIN hklco_hikashop_product AS p ON prod.product_id = p.product_id LEFT JOIN hklco_hikashop_product_category AS cat ON cat.product_id = p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN hklco_hikashop_category AS categ ON cat.category_id = categ.category_id LEFT JOIN hklco_hikashop_address AS b ON a.order_billing_address_id=b.address_id LEFT JOIN hklco_hikashop_zone AS z ON b.address_country=z.zone_namekey WHERE a.order_type='sale' AND a.order_status IN ('confirmed') AND cat.category_id IN ('40','41','42','43','44','45') AND a.order_created > 1493622000 AND a.order_created < 1554069540 GROUP BY z.zone_namekey

Thank you,
It was "Map" report.
Now all is all right!